LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default auto suming

i have the data in this format

name Jan Feb Wed
alan 5 10 15
ben 6 0 3


others 5 10 5
others 1 2 2

what i want is to do 3 suming..one is after the list of name i want it to do
a sum then after which is sum for others. finally do a sum for both name and
other. this is what it shld look like.

name jan feb march
alan 5 10 15
ben 6 0 3
sum 11 10 18

other 5 10 15
other 1 2 2
sum 6 12 17
total 17 22 35

is that a way to do this?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
suming under two condintions Soccerboy83 Excel Discussion (Misc queries) 2 October 28th 09 01:27 AM
suming working ok but now not auto updating totals after changes colin bellamy Excel Discussion (Misc queries) 1 March 16th 08 11:09 PM
testing while suming angryelvis New Users to Excel 3 August 14th 07 05:58 PM
suming in add-ins ajimmo Excel Worksheet Functions 2 October 2nd 06 11:57 PM
suming across sheets netnews.comcast.net Excel Programming 1 July 15th 04 08:23 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"