SUMIF to sum multiple columns of data?

  • Thread starter Thread starter Seve66
  • Start date Start date
S

Seve66

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
 
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.
 
Back
Top