| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the Sum Total of a variable Range
If I have a a series of values in worksheet across several rows and
columns, is there a way programically find the total if the exact number of columns and rows to be summed up is not known? Say that on the 1st sheet b2:g4 have values in them. Row 5 & Column H are blank, but h4 would be the place to put the sum total - being it is the end of the range. In the 2nd sheet the values are b2:L7, with Row 8 & Column M blank. The total would be placed in M7Values are either Numeric or True/False. A user function would be written named "SumScale" example spreadsheet is at http://spreadsheets.google.com/ccc?k...UVjosHuUTsXuJw |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals with variable total/sum location | Excel Programming | |||
| Subtotals with variable total/sum location | Excel Programming | |||
| Total a Variable Based on Another Variable Please | Excel Programming | |||
| Total a Variable | Excel Programming | |||
| variable counter/total | Excel Programming | |||
Threaded Mode
