# Sum Two Columns that Meet X Criteria

#### dskexcel

##### New Member
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!

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Assuming all values are 0 or positive, try the folowing array formula, confirm with CTRL-SHIFT-ENTER, not just ENTER:
Code:
``=SUMPRODUCT(\$C\$23:\$C\$100,IF(\$C\$23:\$C\$100=\$B\$23:\$B\$100,1,--(\$B\$23:\$B\$100=0)))``

Last edited:
Perfect, thank you!

Replies
1
Views
244
Replies
1
Views
264
Replies
6
Views
427
Replies
21
Views
559
Replies
3
Views
366

1,218,899
Messages
6,145,100
Members
450,590
Latest member
Naneng

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back