SUMIF Help

I'm trying to create a reference from another sheet to report on estimated sales by sales rep.

Here is what I tried:

=SUMIF([Sales Rep]:[Sales Rep], "JT Phillips", [Estimate Total]:[Estimate Total])

I get the unparsaeble error.

I need to pull this info into another sheet and then pull it into a dashboard. Can someone help me? Is there an easier way?

TIA!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!