I have a spreadsheet with 5 columns. Column A is Category and Column E is
Amount. It is sorted by Category. I'd like to sum Column E for each value
in Category. E.G. if I have 10 entries with Category = Gas then I want
Column E totaled for the 10 Gas entries. And so forth for all the common
entries in Column A.

Can someone please help?

You can set something like this up for each individual category. For this
example we will use column F and G, starting in row 1.
Starting in F1, enter each individual Category
in G1 enter a formula like this:
=SUMIF(A:A,"=" & F1,E:E)
and simply fill that formula down to the end of your list in column F.


"grok" wrote:

I have a spreadsheet with 5 columns. Column A is Category and Column E is
Amount. It is sorted by Category. I'd like to sum Column E for each value
in Category. E.G. if I have 10 entries with Category = Gas then I want
Column E totaled for the 10 Gas entries. And so forth for all the common
entries in Column A.

Can someone please help?

Would you consider using subtotal please?

On Mar 3, 10:41*am, grok wrote:
I have a spreadsheet with 5 columns. *Column A is Category and Column E is
Amount. *It is sorted by Category. *I'd like to sum Column E for each value
in Category. *E.G. if I have 10 entries with Category = Gas then I want
Column E totaled for the 10 Gas entries. *And so forth for all the common
entries in Column A.

Can someone please help?