Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions |