Thread: sumproduct problem
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
muddan madhu muddan madhu is offline
external usenet poster
  
Posts: 747
Default sumproduct problem
=SUMPRODUCT((Data!B:B=A8)*(Data!C:C=LEFT(B8,3))*(D ata!D:D))


On Oct 22, 9:02*am, Seeker wrote:
HI,
I have sumif formulas which work fine, but when combine them as sumproduct,
result is #NUM!, why?
=SUMIF(Data!B:B,A8,Data!D:D) - answer
=SUMIF(Data!C:C,LEFT(B8,3),Data!D:D) - answer
=SUMPRODUCT(--(Data!B:B=A8),--(Data!C:C=LEFT(B8,3)),(Data!D:D)) - #NUM!
Rgds

Reply With QuoteReply With Quote