I'm having problems with a SUMIFS formula

David Gillies

This one works:

=SUMIF({DOC Ammunition Inventory Range 2}, Category@row, {DOC Ammunition Inventory Range 1})

This one won't:

=SUMIFS({DOC Ammunition Inventory Range 2}, {Sheet - Asset Management Sheet Range Inst}, Category@row, {DOC Ammunition Inventory Range 1})

What am I missing?

JamesB

@David Gillies

On your SUMIFS you do not have a second criteria. SUMIF and SUMIFS build slightly different.

A SUMIF builds RANGE, CRITERION, and if specified a SUM_RANGE, otherwise it will SUM from the selected RANGE.

On a SUMIFS, you will specify the RANGE to sum, then the individual CRITERION RANGES and CRITERIONS.

example

=SUMIFS(RANGE TO SUM,CRITERION RANGE 1,CRITERION 1,CRITERION RANGE 2,CRITERION 2)