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.