Year-to-Date Daily Averages

[Guest]

I have a worksheet with the following column headings

Week 1 Week 2 Week 3 Current YTD Total Current YTD Daily Averag
1/01/04 1/04/04 1/11/0
1/03/04 1/10/04 1/17/0

Faxes 2 3 5 1
Calls 4 7 2 1
Letters 8 7 3 1

The Year-to-Date Daily Average is the YTD total divided by the number of days from the beginning of the year thru the end of the current week. I've tried =D5/(C3-A2+1) and it works until I add in a new column for the current week's figures. What else can I try? I have no statistical or financial background. I'm a newbie

 

[Frank Kabel]

Hi
one way:
- create the columns for all 52 weeks
- The 54th (col.. BB) column will hold your YTD
- and col. BC the average

add the following formula in this column
=AVERAGE(B2:BA2) to get the average per week (blank cells are ignored)

 

[Guest]

Thanks Frank

I did as you suggested but had to find a different formula. I came up wit
B10/(Max($B$7:$BB$8)-$B$7+1) and it updates the YTD Daily Average colum
automatically. In order to keep the value for Max relevant, I leave the date field
for the blank columns empty.

----- Frank Kabel wrote: ----

H
one way
- create the columns for all 52 week
- The 54th (col.. BB) column will hold your YT
- and col. BC the averag

add the following formula in this colum
=AVERAGE(B2:BA2) to get the average per week (blank cells are ignored





-
Regard
Frank Kabe
Frankfurt, German

Cheryl wrote