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
|