Thread: sumif with multiple constraints
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jessica Jessica is offline
external usenet poster
  
Posts: 113
Default sumif with multiple constraints
trying to sum a column ignoring two parameters, only successfully ignoring one.
currently using
=SUMIF(F:F,"<-420") also want it to ignore values of -560 when returning sum.
any help appreciated.
Reply With QuoteReply With Quote