Thread: SUMPRODUCT is not working
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gladiator Gladiator is offline
external usenet poster
  
Posts: 24
Default SUMPRODUCT is not working
here is the formula:

=SUMPRODUCT((('BAC - ABC'!B$5:B$711)=Comparison!B13)*(('BAC -
ABC'!C$5:C$711)=Comparison!C13)*'BAC - ABC'!F$5:F$711)


"Gladiator" wrote:

Hi all,
This formula sometimes works and sometimes shows #VALUE! error. Please
anyone advice. Thanks.
Reply With QuoteReply With Quote