Unique Date and Location filter/index

[gizzorge]

I have data columns for date, location, and sum. For example:

11/15/16 Pittsburgh 25.50
11/15/16 Pittsburgh 16.50
11/15/16 Albany 12.50
11/15/16 Albany 15.50
12/16/16 Pittsburgh 10.25
12/16/16 Albany 16.95

What I would like to do is get total columns that get grand totals for each day and location...
So the resulting three columns would look like this:

11/15/16 Pittsburgh 42.00
11/15/16 Albany 17.00
12/16/16 Pittsburgh 10.25
12/16/16 Albany 16.95

Not quite sure how to use formulas to get things working like this. Any help would be greatly appreciated!

George

 

[63falcondude]

There are a few ways of doing this. You can use a pivot table with Date and Location as Row Labels and Sum as Values or you can copy and paste columns A and B elsewhere, remove duplicates, and then use a formula such as:

Excel 2010
	A	B	C	D	E	F	G
1	Date	Location	Sum		Date	Location	Sum
2	11/15/2016	Pittsburgh	25.5		11/15/2016	Pittsburgh	42
3	11/15/2016	Pittsburgh	16.5		11/15/2016	Albany	28
4	11/15/2016	Albany	12.5		12/16/2016	Pittsburgh	10.25
5	11/15/2016	Albany	15.5		12/16/2016	Albany	16.95
6	12/16/2016	Pittsburgh	10.25
7	12/16/2016	Albany	16.95
Sheet1

Cell Formulas
Range	Formula
G2	=SUMIFS(C:C,A:A,E2,B:B,F2)

 

[Declamatory]

Have you thought of using a pivot table?

 

[gizzorge]

Pivot table was just what I needed. Didn't even think about that.
Thanks a ton!!