| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total varying no of columns
I had originally posted this yesterday to Worksheets function but the
Group doesn't seem to be active. I am trying to total columns L2:AA2 (there are 400 rows) but the no of columns to be totalled will be based on a week number in H2. For example, current week no is 2 so Excel would total L2+M2. The week no increases by 1 every week. Can it be done? Thanks Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup columns (varying qty), then find MIN | Excel Worksheet Functions | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| Summation of columns of varying heights? | Excel Discussion (Misc queries) | |||
| how do i add up 3 columns to get a total | New Users to Excel | |||
| Transpose rows to columns w/varying numbers of lines per record | Excel Worksheet Functions | |||
Threaded Mode
