Thread: DSUM or SUMPRODUCT?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vass
 
Posts: n/a
Default DSUM or SUMPRODUCT?

"Bob Phillips" wrote in message
...
It does each E by each W where DA satisfies the condition.

=SUMPRODUCT(--(data!DA2:DA7199="RETAILAC"),data!E2:E7199/1000,data!W2:W7199/
1000)


thanks Bob


Reply With QuoteReply With Quote