Thread: Problem with SUMIF criteria
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Problem with SUMIF criteria
Kim,
this formula should do your job.

SUMPRODUCT($G$3:$G$2001*--(COUNTIF(M3:M100,$A$3:$A$2001)<0))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote