sumif

[Judith]

In the "sum range" part of the sumif formula, I want to sum multiple columns.
Only the first column is being recognized. Can it be done?

 

[Jacob Skaria]

With SUMIF() You cannot. Instead use SUMPRODUCT() or SUMIFS() available with
2007

To SUM
--For a single criteria SUM you can use
=SUMIF(A:A,criteria,BB)

--When you have multiple criteria use SUMPRODUCT()
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2),C1:C10)

If you are using Excel 2007 you can use SUMIFS() to acheive the same result
=SUMIFS(C1:C10,A1:A10,criteria1,B1:B10,criteria2)

'or with cells F1 and F2 holding the criteria
=SUMIFS(C1:C10,A1:A10,F1,B1:B10,F2)

If this post helps click Yes

 

[T. Valko]

Try something like this:

A1:A10 = criteria range
B110 = sum range

=SUMPRODUCT((A1:A10="x")*B110)