B
Brian
=SUMPRODUCT(--(Sheet1!B2:B200="D"),--(Sheet1!C2:C200=4),D2200)
When I use this formula, the result is 0.
A B C D
1 D 4 2
2 B 2 3
3 D 5 5
4 A 2 2
When I use this formula, the result is 0.
A B C D
1 D 4 2
2 B 2 3
3 D 5 5
4 A 2 2