SUMIF Contact? Help please!

LukeFortney
LukeFortney ✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to get the total of a column where the row contains a specific sales person. Can someone help me out?

Here is what I tried:

=SUMIF([Sales Person]:[Sales Person], "Kevin", [Appx. Value]:Appx. Value])

Screenshot attached...thanks in advance!

Smartsheet.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!