View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
PY & Associates[_2_] PY & Associates[_2_] is offline
external usenet poster
 
Posts: 38
Default Need spreadsheet 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?