| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif not criteria
That worked perfectly, thanks so much!
"RagDyeR" wrote: It's a little different when using a cell reference: =SUMIF(C122:C127,"<"&$C$2,D122:D127) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "doublew" wrote in message ... I should also maybe add that I'm trying to use a cell reference as my criteria - does this make a difference? I'm trying to do =SUMIF(C122:C127,"<$C$2",D122:D127) but it just sums everything, without taking into account the criteria. "doublew" wrote: I'm having the same problem. I tried Domenic's suggestion but didn't work - any others? "Domenic" wrote: Try... =SUMIF(A1:A100,"<X",B1:B100) Hope this helps! In article , CCrew2000 wrote: I'm trying to sum a column of data "B", but only if column "A" does not equal X. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Multiple SUMIF Criteria | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
