Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Total column changes colors when total equals sum of other columns | New Users to Excel | |||
disable Total and/or Sub total for a single column | Excel Worksheet Functions | |||
XL formula - total of row = total of column | Excel Worksheet Functions |