# Multiple Column Search and Sum

#### hoffkeit

##### New Member
My worksheet is currently laud out in this format:

Column A Column B Column C Column D
Product Type Date I.D. Number Amount

I want to write a formula for the sum of each amount in column D between certain dates in column B, for certain I.D. Numbers in Column C. I have tried SUMIF formulas, VLOOKUP formulas, and IF formulas, but I can seem to get it right. Any ideas?

Thank you!

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### tybaltlives

##### Active Member
Did you try SUMIFS ? this allows for multiple criteria. In your case, you want a sum between specific dates. =SUMIFS(sum column D,B range,">"&date,B range, "<"&date, C Range, "="&ID#1, etc.)

I can see an issue with the ID number column. You say "certain" ID numbers. You will need to list out the idnumbers you want to look for and ensure there are criteria for them. If you can limit the ID numbers you are searching for to 5, then you will need 5 criteria.

Here is an example of a SUMIFS formula I just did. Its not exactly what you are looking for but it might get you started.

http://www.mrexcel.com/forum/excel-questions/748856-comparing-lists-sum-matches.html

Replies
1
Views
162
Replies
2
Views
109
Replies
6
Views
78
Replies
3
Views
224
Replies
4
Views
221

1,130,185
Messages
5,640,679
Members
417,160
Latest member
Timon82

### 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