Hello,
I'm working with this data:
View image: Capture
I could just use the following formula in cells D23:D100: =IF(OR(B2=C2, and(B2=0, C2>0)), C2, 0) and then sum D23:D100 to get the total I'm looking for.
However, I need a formula that will give me that sum in one cell. Any ideas?
Thanks!
I'm working with this data:
View image: Capture
I could just use the following formula in cells D23:D100: =IF(OR(B2=C2, and(B2=0, C2>0)), C2, 0) and then sum D23:D100 to get the total I'm looking for.
However, I need a formula that will give me that sum in one cell. Any ideas?
Thanks!