Sumproduct - number & text
If you use that * operation, then if you have any non-numeric entries in
D2:D100, then you'll get that error.
But if you change your syntax:
=SUMPRODUCT(--(Sheet2!$C$2:$C$100=$C$2),
--(Sheet2!$B$2:$B$100=R4),
--(Sheet2!$D$2:$D$100))
Text in D2:D100 will be treated as 0--just like =sum().
Kashyap wrote:
Hi, I have number in colB & text in Col C,D
I was trying sumproduct to go the data from colD looking at Col B & C
something like below.. But result is #VALUE!
=SUMPRODUCT((Sheet2!$C$2:$C$100=$C$2)*(Sheet2!$B$2 :$B$100=R4)*(Sheet2!$D$2:$D$100))
Can someone help me on this pls...
--
Dave Peterson
|