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?

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?

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?