Thread: Do I need SUMPRODUCT?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DaveMoore DaveMoore is offline
external usenet poster
  
Posts: 32
Default Do I need SUMPRODUCT?

Got it!

=SUMPRODUCT(($D$2:$D502=D507)*($F$2:$F502="")*($E$ 2:$E502))

works for me.

Are there any shorter versions?

Reply With QuoteReply With Quote