help with formula
I did not finish b4 posting.
if you look at the example that i used, the result with this formula should
be 2. But again I am getting 0. It's supposed to find where column B has a
"D" and then look in the same row over to column C and if there is a "4"
there, then sum the hours in column D
Thank You
Brian
"Brian" wrote:
=SUMPRODUCT(--(Sheet1!B2:B200="D"),--(Sheet1!C2:C200=4),D2:D200)
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
|