SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET

Drew Frazelle
Drew Frazelle ✭✭✭
edited 08/15/22 in Formulas and Functions

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!