Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad Bross Brad Bross is offline
external usenet poster
 
Posts: 3
Default SUMIF

I have a formula with criteria which excludes "0148" from the sum.
=SUMIF(E$51:E$56,"<0148",O$51:O$56). I would also like a formula which
would exclude both "0148" and "0101" from the sum. I tried many variations
e.g. =SUMIF(E$51:E$56,"<0101AND<0148",O$51:O$56) to get this to work and
cannot obtain the correct results. Thx for your help.

Brad Bross