Thread: sumif problems
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default sumif problems
#1:
=SUMPRODUCT(--($A$2:$A$10<"S"),D2:D10)

#2:
=SUMPRODUCT(--($A$2:$A$10<"S"),D2:D10+E2:E10)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote