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


"Bob Phillips" wrote
=SUMPRODUCT(--(data!DA2:DA7199="RETAILAC"),--(data!E2:E7199,data!W2:W7199))

returns #VALUE!

I can see what your doing but can't fix it
--
Vass




Reply With QuoteReply With Quote