View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bubu Bubu is offline
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.