Thread: Sumif not criteria
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default Sumif not criteria
Try...

=SUMIF(A1:A100,"<X",B1:B100)

Hope this helps!

In article ,
CCrew2000 wrote:

I'm trying to sum a column of data "B", but only if column "A" does not equal
X.
Reply With QuoteReply With Quote