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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total varying no of columns
=Sum(Offset(L2,0,0,1,$H$2))
Assume you are summing each row separately. If the column count varies by row and column H has the week number, take the $ signs off H2. Now drag fill your formula downt the column. -- Regards, Tom Ogilvy wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total varying no of columns
Perfect. Thank you Tom.
Regards Tony |
Reply |
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 |