Find sum by matching multiple criteria

[mark91345]

My goal is to sum up the total Volume of a particular stock on a daily basis. The stock may be listed on one, or both, exchanges. If the Dates are the same, I want to add up both Volume totals; if the stock is listed on one Date only, then that needs to be shown as well.

I have tried vlookup and sumifs, but because there are 3 criteria (Stock, Date, & Exchange), it is beyond my ability (at the moment). Thank you.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Stock	Date	Exchange	Volume			Total Volume 8/1/2017	Total Volume 8/2/2017	Total Volume 8/3/2017	Total Volume 8/4/2017	Total Volume 8/5/2017	Total Volume 8/6/2017
2	APPLE	8/1/17	Nasdaq	4,600		Apple	4,600				30,050
3	APPLE	8/5/17	Nasdaq	12,550		Dell				2,000
4	APPLE	8/5/17	NYSE	17,500		HP		1750	5000			15,000
5	DELL	8/4/17	Nasdaq	2,000		Microsoft	20,500		1500
6	HP	8/2/17	Nasdaq	1,750
7	HP	8/3/17	Nasdaq	5,000
8	HP	8/6/17	Nasdaq	4,000		My goal is to sum up the daily Volume of a particular stock.
9	HP	8/6/17	NYSE	11,000		For example, on 8/1/17, Apple was traded on only one exchange,
10	MICROSOFT	8/1/17	Nasdaq	11,500		so it's total Volume is listed above.
11	MICROSOFT	8/1/17	NYSE	9,000		But, on 8/5/17, Apple was traded on two different exchanges,
12	MICROSOFT	8/3/17	NYSE	1,500		so its total is summed up & shown accordingly.
13
Sheet1

 

[Joe4]

You can do this with SUMIFS.
My first recommendation is to break up your title row so that cells G1:L1 all say "Total Volume", and cells G2:L2 have the dates, in valid date format.
Then, your data is in rows 3:13.

So then just enter this formula in cell G3, and copy all the way to L6:

=SUMIFS($D$3:$D$13,$A$3:$A$13,$F3,$B$3:$B$13,G$2)

 

[mark91345]

Thank you Joe4, this is exactly what I needed.

Mark

 

[Joe4]

You are welcome!

The key here is the proper use of Absolute Range referencing, knowing when to lock down the row reference and knowing when to lock down the column reference.
If you need a primer on that, check out this link: http://www.excel-easy.com/functions/cell-references.html