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.
|