# SUM and SUMIF giving unexpected results

Simple SUM and SUMIF giving odd results.

For the same sheet,

SUMIF should add up C1 thru C100 if E1:E100 contains "text". Ex - "=SUMIF(E1:E100, "text", C1:C100)"

SUM should add up C1 thu C100. Ex- "=SUM(C1:C100)"

SUMIF gives me a figure much larger than expected. SUM gives me a figure much smaller than SUMIF. This is odd since there are significantly fewer E cells containing "text".

I'm at a loss at the moment. Needless to say, I am not very familiar with Calc.

Oh, and why, oh why, does my Captcha present me with languages I do not easily comprehend? My language preference is set to English.

OK, so SUMIF is my error in expectation. Some testing and old fashioned calculator proved that. But I am still baffled as to why a simple SUM is so much smaller.