Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF Problem
Hi Julie,
Remove the " marks and the equal sign. The " signify text and the = sign is not needed HTH "julie" wrote: 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 |
#2
|
|||
|
|||
SUMIF Problem
Julie,
I entered your identical data and in C1 entered =sumif(A:A,2,B:B) and it worked fine for me "julie" wrote: Ray- Thanks. I did try that (just tried it again). It doesn't make a difference. I also made sure column A was numeric by-the-way. Any other thoughts would be appreciated. -- Julie "Ray A" wrote: Hi Julie, Remove the " marks and the equal sign. The " signify text and the = sign is not needed HTH "julie" wrote: 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 |