How add SUBtotals to a large Excel spreadsheet
How can I have Excel calculate SubTotals on a spreadsheet ... something like this:
Cars 2
Cars 5
Cars 8 15
Trucks 3
Trucks 1
Trucks 2
Trucks 7 13
etc
I have the first 2 columns, and want Excel to calculate the 15, 13, etc.
Cars 2
Cars 5
Cars 8 15
Trucks 3
Trucks 1
Trucks 2
Trucks 7 13
etc
I have the first 2 columns, and want Excel to calculate the 15, 13, etc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In addition to above suggestion, have you seen the SUBTOTAL feature on the Data Group tab.
You can tell excel to look for a change in a particular column of your data and add a subtotal (count or sum and others) to another column.
This will insert a row below each set of data and will populate this new row with the subtotal formula. It will also add grouping to the sheet so you can expand or collapse each set individually or expand/collapse all sets to a specific level at the same time.
Thanks
You can tell excel to look for a change in a particular column of your data and add a subtotal (count or sum and others) to another column.
This will insert a row below each set of data and will populate this new row with the subtotal formula. It will also add grouping to the sheet so you can expand or collapse each set individually or expand/collapse all sets to a specific level at the same time.
Thanks
ASKER
Thanks for the suggestion Rob! I'll take a look at that as well.
- B
- B
ASKER
Thank you.