Need spreadsheet help

  • Thread starter Thread starter grok
  • Start date Start date
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?
 
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
suming under two condintions 2
How do I create a click on + symbol to open a root and click on -. 1
Insert new row automatically 1
SUMIFS function help 6
Auto populate this cell based on what's typed in this cell 2
Need to average division of two columns based on criteria 4
format new rows 2

Back
Top