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: 21
Default Total by Selection by Column, Help Please.

Suppose i select a certain range, then a start a macro.
i want that macro to sum all the values for each column
included in my selection and to have the results just below.


suppose i have a situation like this :
A B C
----------------------------
1 3 9 7
2 5 1 8
3 1 5 3
3 2 1 1


I select range A1:C3, i start the macro, then i have the results like this ...

A B C
----------------------------
1 3 9 7
2 5 1 8
3 1 5 3
3 2 1 1
----------------------------
4 11 16 19

Important Note : range A1:C3 may be whatever, like F7:M26 or B9:F12,
for the case F7:M26 the results will be in F27:M27
for the case B9:F12 the results will be in B13:F13

Any Help ?

Best Regards.

Robert.
 
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
Count number of cells and total in one column, based on another column suffix Pierre Excel Worksheet Functions 5 October 31st 07 12:28 AM
Total column changes colors when total equals sum of other columns newstacy New Users to Excel 1 April 21st 07 09:00 PM
disable Total and/or Sub total for a single column Voyager Excel Worksheet Functions 3 February 14th 07 10:51 PM
XL formula - total of row = total of column topaz Excel Worksheet Functions 2 March 17th 05 10:04 PM


All times are GMT +1. The time now is 06:41 PM.

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

About Us

"It's about Microsoft Excel"