Strange Problem with SUMPRODUCT and/or SUMIF

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

Hi,

I'm experiencing a strange problem with the following data sheet. It occurs
whether I use SUMPRODUCT or SUMIF.

SUMIF(C81:C134,C81,K81:K134)

SUMPRODUCT(($C81:$C134="Q-School")*(K81:K134))

Data:
1 2 3 4 Money
Q-School 68 69 65 70 1
Q-School 71 68 68 73 2
Q-School MC 71 71 3
Q-School MC 73 69 4
Nationwide 69 66 72 73

What happens is, I want to total the value in the Money column IF the first
column equals Q-School. That works ok but what is happening is the 4th row
value is also being loaded into the Money column of the 5th row.

In other words, instead of seeing the sum of the Money column as

10 (value of column Money rows 1 through 4)
0 (should be 0)

I see

10 (value of column Money rows 1 through 4)
4 (value of column Money row 4 has been loaded here)

Why?

Should I set all of the cells = 0?

Thanks, Raymond
 
I think you have to explain a bit more, what do you mean with"
"value of column Money row 4 has been loaded here"
where has the value been loaded?
Where is the formula? In your description it looks like the formula is above
the "loaded" value
 
Hello Peo,

I'm sorry, it was difficult to explain but I figured out what the problem
is. Isn't that the way, as soon as you post something you figure it out.

Thank you for your speedy reply and help.

Take care,

Raymond Tompkins
 
Back
Top