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

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

Annotation 2020-05-05 063345.jpg

Annotation 2020-05-05 0633451.jpg

Paul Newcome

Try this...

=SUMIFS({Total}, {Facility}, Description@row)

Paul Newcome

Try this...

=SUMIFS({Total}, {Facility}, Description@row)