Thread: how to sumif in excel with a not equal criteria
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default how to sumif in excel with a not equal criteria
=SUMIF(A:A,"<apples",B:B)

Vaya con Dios,
Chuck, CABGx3


"Ed" wrote in message
...
Hi I'm trying to use the sumif function but I want to sum everything in a
range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
sum everything that is not equal to apple should return 20. Thank you


Reply With QuoteReply With Quote