Need spreadsheet help

G

grok

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?
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

series of sums in a long spreadsheet 1
How do I create a click on + symbol to open a root and click on -. 1
Auto concantenate 1
Returning MULTIPLE values with Index and Match 1
Sum with multiple conditions - sumproduct, dsum or dproduct? 3
Need to average division of two columns based on criteria 4
Most frequent string in a column matched against a value in its ro 1
suming under two condintions 2

Top