Do you mean SUMIF can only have simple, "", "<" and "=" comparison and all
the AND and OR functions won't work in SUMIF?

Thanks




"Bob Phillips" wrote in message
...
=SUMIF(A1:A33,"50")-SUMIF(A1:A33,"70")

this will include 70, use = if you want to exclude it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Lamb Chop" wrote in message
...
How can I sum B1:B33 if A1:A33 is in between 50 and 70 ?

I have tried this, but I only got 0

=SUMIF(A1:A33, "AND(50, <70)", B1:B33)



Thanks