I am trying to write a sumifs formula that sums to create a year to date total
Options
Ron Anderson
✭✭✭✭
I am writing a sumifs formula that is returning incorrect argument. I want to sum gross commissions based that occur with a date this year and where the agent = the value in the agent column.
Current formula
=SUMIFS({Gross Commission}, ({Execution Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), {Agent Name 2}, [Agent Name]@row)
Thanks
Answers
-
Remove the parenthesis from before {execution date} and after Today())
=SUMIFS({gross commissions}, {execution date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Community Help Sheet Range 2}, [Agent Name]@row)
Melissa Boehl
Smartsheet Architect | TurningPoint Energy
-
That did it. Thanks so much
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!