subtotaling large data set
 

I am dumb. There are a million examples almost exactly like this, but none
that I can find that is precisely the same, and I can't figure it out.

The problem: Subtotaling a large data set.

Say I have three columns:

A B C
1. apple 3 4
2. apple 4 5
3. orang 3 2
4. cran 3 1
5. zebra 9 3
6. zebra 2 1
98. car 4 3
What I would like to do, is subtotal col "B" & "C" if "A" is the same.. So,
if it is apples, sum up all the B's and put it somewhere, & sum up all the
c's and put it somewhere. Is this possible, without going typing in each
manually, or summing individually?

Thanks a million to the genius that is most gracious to help me out!

Hi,
One way,
Highlight all the rows in Columns A, B and C. Go to Data Sort... and
accept the default as Sort by Column A. Click OK.
Go to Data Subtotals... and click OK when you get the warning box.
In the Subtotal dialog box, select "At end change in:" = apple, "Use
function:" = Sum, and check the 3 and 4 in the "Add subtotal to:" box.
Then click OK.

"Wedge" wrote:

I am dumb. There are a million examples almost exactly like this, but none
that I can find that is precisely the same, and I can't figure it out.

The problem: Subtotaling a large data set.

Say I have three columns:

A B C
1. apple 3 4
2. apple 4 5
3. orang 3 2
4. cran 3 1
5. zebra 9 3
6. zebra 2 1
98. car 4 3
What I would like to do, is subtotal col "B" & "C" if "A" is the same.. So,
if it is apples, sum up all the B's and put it somewhere, & sum up all the
c's and put it somewhere. Is this possible, without going typing in each
manually, or summing individually?

Thanks a million to the genius that is most gracious to help me out!