Sum values based upon multiple sets of criteria

Perkins15

New member
Joined
Dec 7, 2012
Messages
1
Reaction score
0
Points
0
Here is my situation:

I have a spreadsheet that contains almost 5,000 rows and need a formula or someway fo make it easier to format. I am currently working in excel 2007 but do have access to 2010.

Column A: Dates
Column B: Dollar Amount
Column C: Name
Column F: Number

I want to total the values in column F based on if the Column A values are the same AND if the values in Column B are the same AND if the values in Column C are the same.

It would also be great if I could automatically get excel to insert a blank row in between each total so that the spreadsheet is easier to view.

Any help would be greatly appreciated. I don't know where to start.

Thanks,
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
If it is sorted, look at Data>Subtotals.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Not quite sure if I replicated your data correctly, but take a look at this...

If I'm off base, maybe attach a workbook with some sample data of what you have, and what you'd like to see. (Click "Go Advanced" at the bottom right to upload a workbook)
 

Attachments

  • xlgf1288-1.xlsx
    9.3 KB · Views: 12
Top