SUMIF to sum multiple columns of data?
 

Help Please!
I am trying to use the SUMIF function to sum multiple columns of data.
example.
My Range is A1:A7, Criteria is "W", Sum_Range is B1:G7
The answer should be 31 but the formula won't return 31!

There are blank rows in the Range!

A B C D E F G
1 W 2 3 0 4 0 5
2
3 D 1 1 1 1 1 1
4
5 S 1 1 1 1 1 1
6 W 2 4 1 2 3 5
7 C 0 0 0 0 0 0

SUMIF to sum multiple columns of data?
 

=SUMPRODUCT((A1:A7="W")*(B1:G7))

--
__________________________________
HTH

Bob

"Seve66" wrote in message
...
Help Please!
I am trying to use the SUMIF function to sum multiple columns of data.
example.
My Range is A1:A7, Criteria is "W", Sum_Range is B1:G7
The answer should be 31 but the formula won't return 31!

There are blank rows in the Range!

A B C D E F G
1 W 2 3 0 4 0 5
2
3 D 1 1 1 1 1 1
4
5 S 1 1 1 1 1 1
6 W 2 4 1 2 3 5
7 C 0 0 0 0 0 0

SUMIF to sum multiple columns of data?
 

Hi,

The sumrange of the SUMIF function must be a single column or a single row.
In place of SUMIF you can use an array sum or SUMPRODUCT. You already have a
SUMPRODUCT solution so here is an array solution:

=SUM((A1:A7=I1)*B1:G7)

To make it an array you must enter it by pressing Shift+Ctrl+Enter. I1
contains W in this example.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Seve66" wrote:

Help Please!
I am trying to use the SUMIF function to sum multiple columns of data.
example.
My Range is A1:A7, Criteria is "W", Sum_Range is B1:G7
The answer should be 31 but the formula won't return 31!

There are blank rows in the Range!

A B C D E F G
1 W 2 3 0 4 0 5
2
3 D 1 1 1 1 1 1
4
5 S 1 1 1 1 1 1
6 W 2 4 1 2 3 5
7 C 0 0 0 0 0 0