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...