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

05/05/20
Answered - Pending Review

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


Answers

Sign In or Register to comment.