Sumifs with multiple criteria

alexjulian

New Member
Joined
Nov 29, 2016
Messages
2
Hello all,

I have a worksheet (Tab A) with securities data that looks something like this:

Michigan Series 2007 1/1/2015 $1,500,000
Michigan Series 2007 1/1/2016 $1,800,000
Michigan Series 2008 1/1/2016 $1,000,000
Ohio Series 2005 1/1/2015 $1,500,000
Ohio Series 2005 1/1/2015 $1,600,000
Ohio Series 2005 1/1/2017 $1,550,000
California Series 2009 1/1/2015 $2,500,000
California Series 2009 1/1/2015 $1,000,000

And another worksheet (Tab B) where I have only unique values from the first three columns. So, something like this:

Michigan Series 2007 1/1/2015
Michigan Series 2007 1/1/2016
Michigan Series 2008 1/1/2016
Ohio Series 2005 1/1/2015
Ohio Series 2005 1/1/2017
California Series 2009 1/1/2015

Basically, what I need to do is sum the numbers in the fourth column of Tab A only if all three values in the first three columns match those in Tab B. For example, for the row that contains "Ohio Series 2005 1/1/2015," I want $3,100,000 to be returned. All three values in the first column must match those in Tab B in order to sum.

Thanks for your help!
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sorry for the poor formatting (first thread!) - the columns should look like this:

Column 1
Column 2
Michigan Series 2007 etc.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top