SUMIF to sum multiple columns of data?

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
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top