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?