How to SUMIF with an array in Google Sheets

Question

I can not get this calculation to work.

=SUMIF({C3,E3,G3,I3,K3,M3},"N",{D3,F3,H3,J3,L3,N3})

The array as the RANGE works fine but the array as the SUM_RANGE returns the error message:

Argument must be a range

Can anyone help me?

Thanks, Dean.

Answer 1

Please try filter with offset:

=SUM(FILTER(D3:N3,C3:M3="B"))

why it's better:

• you use the entire ranges.
• the formula is shorter
• easy to add other conditions in a filter.

Edit

See also sumif with offset:

=SUMIF(C3:M3,"B",D3:N3)

Answer 2

Not tested but see if this works

=SUMPRODUCT({C3,E3,G3,I3,K3,M3}="N",{D3,F3,H3,J3,L3,N3})