Thread: the proper use of sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lamb Chop Lamb Chop is offline
external usenet poster
  
Posts: 38
Default the proper use of sumif
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



Reply With QuoteReply With Quote