Autogroup then sum - can it be done?

[Jessica Robinson]

This is what I would like to do, if possible:

Sum the values of column B that correspond with a set of unique row entries
in column A. The sum should go on the first of the unique set rows in Column
C. But, for example...

Column A:
Apples
Apples
Apples
Oranges
Oranges
Oranges
Pears

Column B:
2
3
2
2
2
2
2

Column C:
7
-
-
6
-
-
2

I found instructions on how to do something similar
(http://tipsforspreadsheets.com/microsoft_excel_2003_function_0027.html), but
it requires that you type the different things in column A into the formula.
I want excel to be able to group the things in column A automatically and
then sum the corresponding column B numbers of that group. Why? Because there
are 350 unique row values in Column A in my actual data. I just want to make
one formula, or function, or whatever - not 350 of them.

Is that possible? Or am I just wasting time when I could be autosumming each
group manually instead of looking for an automatic way to do this?
Unfortunately, autosum is really about the extent of my knowledge of
formulas, functions or whatever-they-ares, so that's why I need some help.

Thank you bunches!

 

[Teethless mama]

Try Pivot table

 

[John]

Hi Jessica
If your product starts in A2, try this formula and copy down.
=IF(A2=A1,"",SUMPRODUCT(--(A2:A10=A2),B2:B10))
HTH
John

 

[Ashish Mathur]

Hi,

you may highlight the data and go to Data > Subtotals. Supply the relevant
inouts

 

[Jessica Robinson]

John, this worked perfectly! Thank you so much.
~ Jessica

 

[John]

You're welcome.
Thanks for feeding back
John

John, this worked perfectly! Thank you so much.
~ Jessica