Thread: I need a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default I need a formula
Hi,
Not quite sure if this is what you want, but try:
=SUMPRODUCT(--(ISNUMBER(FIND("April",C207:C209)))*(D207:D209))
or
=SUMPRODUCT(--(ISNUMBER(FIND("May",C207:C209)))*(D207:D209))
Change refs to suit.
Regards - Dave.
Reply With QuoteReply With Quote