SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
Options
Drew Frazelle
✭✭✭
Hello all,
I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({Total}, but when I add the criteria for each department I get # INCORRECT ARGUMENT SET. What am I missing? Please see attached screenshots. Thank you in advance.
~Drew
Best Answer
-
Try this...
=SUMIFS({Total}, {Facility}, Description@row)
Answers
-
Try this...
=SUMIFS({Total}, {Facility}, Description@row)
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!