SUMIF Problem
I'm trying to use SUMIF and the results appear to be wrong. I've checked to
be sure that the values in column B are truly numbers (not text) and they are
numbers. Column C1 is where the formula resides and the sum should be
583.50. I watched what happening using the Function Wizard, and for the
sum_range it is = {516;67.50}. Also tried taking the = out of the criteria
argument and it doesn't matter. Any ideas?
=SUMIF(A1:A1,"=2",B1:B2)
A B C
2 516.00 516
1 67.50
Thanks for your help,
--
Julie
|