SUMIF Contact? Help please!

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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!