sumif
 

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?

sumif
 

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
---------------
Jacob Skaria


"Judith" wrote:

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?

sumif
 

Try something like this:

A1:A10 = criteria range
B1:D10 = sum range

=SUMPRODUCT((A1:A10="x")*B1:D10)

--
Biff
Microsoft Excel MVP


"Judith" wrote in message
...
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?