Cross Sheet Reference/ sum values

edited 12/09/19 in Formulas and Functions

Looking to VLOOKUP into one data sheet to find

- a sales rep name where the sales stage is contracted and sum up the Estimated Value field, which sums up any dollar amount in the (estimated value) field. End result is to show a sales rep and how much they have contracted to close via a dollar amount.

My formula example:

=COUNTIFS({Sales Stage}, ="FU-6", {Sales Rep}, ="Phil", {Est Value}, = "???")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!