SUMIF function

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

It does not seem that the CRITERIA can be a cell
reference, such as "<$b9". If so, this is a shame. Is
there a way to do this, say using some other indicator
rather than quotes around it, to tell EXCEL it is a cell
reference?

Thx,
G
 
Wow, works great - where did you learn that? One more
thing: is there a way to have two criteria, such as <2 and
 
Hi Grace
SUMIF works only with one criteria. So for your example you can use
either of the following:
=SUMIF(A1:A10,"<2") - SUMIF(A1:A10,"<=1") -> you can replace the
values with cell references as shown by Laura:
=SUMIF(A1:A10,"<"B1) - SUMIF(A1:A10,"<=" &B2)

or you can use SUMPRODUCT:
=SUMPRODUCT((A1:A10<B1)*(A1:A10>B2),A1:A10)

HTH
Frank
 
Thanks for the help. The first way seems to work fine.
I'm haviung trouble with the second but the first is good
enough, if less elegant!
 
Back
Top