Help with Offset function
Posted by David on December 06, 2001 5:55 AM
I am working with a small data set consisting of Date, Total1 and Total2 (web
server hits for the past years) information is added daily. I need to
automatically grab the last week, month, 3 months of data from the Total1 and
Total2 columns and come up with a daily averages with out having to
individually select the cells. I have been using the following formula
Where C117 is the start of the data and C5000 is the random end (I am up to
For a week worth of data B97 will equal 1 to 7 for a month 1 to 30.
There are several problems with this approach. Although it is semi
automated I have to have an entry for each "day" that I want to grab which I
then average is a separate cell.
Is there a way to specify a range of cells to grab?
Here is what the data sheet looks like.
Date Total1 Total2
1-Nov-00 1,865,476 1,188,997
2-Nov-00 1,860,732 1,178,239
3-Nov-00 1,665,276 1,089,830
4-Nov-00 1,882,132 1,259,914
5-Nov-00 2,181,684 1,435,451
Help would be much appreciated