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