Sum Two Columns that Meet X Criteria

[dskexcel]

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!

 

[MarcelBeug]

Assuming all values are 0 or positive, try the folowing array formula, confirm with CTRL-SHIFT-ENTER, not just ENTER:

=SUMPRODUCT($C$23:$C$100,IF($C$23:$C$100=$B$23:$B$100,1,--($B$23:$B$100=0)))

 

[dskexcel]

Perfect, thank you!