Array arguments to SUMIFS are of different size ERROR CODE

Question

I am using the following code, but am receiving the 'array arguments to sumifs are of different sizes' error code :

=SUMIFS(Expenses!I:I,$A$30,Expenses!B:B,B1,Expenses!H:H)

Any helpful ideas on how to fix?

=SUMIFS(Expenses!I:I,$A$30,Expenses!B:B,B1,Expenses!H:H)

Need name column, amount column and quarter period from expense sheet to populate in a cell that falls in a particular row/column combo.

Answer 1

SUMIFS requires the first argument to be the range that you need to sum up, followed by pairs of condition range and criteria. Documentation. In this regard it is different from SUMIF that has different order of arguments.

In your case the order should be (if Expenses!H:H is the range to sum up):

=SUMIFS(Expenses!H:H, Expenses!I:I,$A$30,Expenses!B:B,B1)