Thread: Sumif not criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JethroUK©
 
Posts: n/a
Default Sumif not criteria
=Sum(A1:A3)=x*SUM(B1:B3)


"CCrew2000" wrote in message
...
I'm trying to sum a column of data "B", but only if column "A" does not
equal
X.


Reply With QuoteReply With Quote