Thread: #ref error with Sumproduct
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default #ref error with Sumproduct
Hi Dennis,

To be on the safe side, and avoid formatting issues :

=SUMPRODUCT(--('ALL FF TLING'!$D$2:$D$1200=A$9)*--('ALL FF
TLING'!$C$2:$C$1200=A10))


HTH
Carim

Reply With QuoteReply With Quote