View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DP DP is offline
external usenet poster
 
Posts: 58
Default Subtotals / Grand Total

This should be so simple but I cant figure out how to get a Grand Total cell
B16 without naming each sub total cell. I used 'auto sum' icon to get a
subtotal on b5, b10, b14. Help lost me on paste functions, math, sum because
I got a sum that included the sub totals as another entry. Obviously I am a
very new Excel user. TIA
Col A Col B
Mr. Smith
January 5.00
February 6.00
March 7.00
18.00

ABC Co
January 15.00
February 20.00
35.00

DEF Co
January 10.00
10.00

Grand Total ?