sumif(range,"<30",sum range) not summing values that equal 0

**rantarctica** · 01-06-2009, 06:59 PM

I have a simple sumif formula that says

=SUMIF(W61:W112,"<30",J61:J112)

In column W, there are values ranging from 0 to 5000.

If the formula is written like it is above, it excludes summing values from column J when the cell in column W equals 0. Why is this? I can just add another function that says sumif "=0", but I don't think I should have to.

Can anyone explain this?

Thanks a lot

**shg** · 01-06-2009, 07:04 PM

Post the workbook?

**rantarctica** · 01-06-2009, 07:15 PM

i had to remove it from its whole workbook (8mb and some stuff i cant post publicly). however, in this new workbook i moved the worksheet into, the problem persists

the cell in question is B23 (highlighted in red)

notice if you type "=0" where the formula says "<30", that works

thanks