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