AVERAGE question

[Dave Horne]

In Column B I have numbers entered on a daily basis. I would like to see
the weekly average of those numbers in column D.

Thanks in advance, Dave Horne

 

[Gary''s Student]

In Column D enter:

=AVERAGE(B1:B7)
=AVERAGE(B8:B14)
=AVERAGE(B15:B21)

and continue down as far as you need.

 

[MartinW]

Hi Dave,

You need to post a lot more information.

Is it one number a day or several numbers a day?
Is a week 5, 6 or 7 days?
Do the numbers just run down the column or are they separated into blocks?
Where exactly do you require the average to show up?

Also add anything else that you can think of to describe
exactly what it is you are trying to achieve.

Also as to your previous post only you can delete it
there are no moderators here.

Regards
Martin

 

[Dave Horne]

Martin, the entries in column B are daily and singular. I just want to see
a weekly average (in column D) using that information.

Regarding that other post, I post through a news reader can not delete that
post.

Thanks, Dave Horne

 

[MartinW]

With your data in B1 down
put this in D7
=AVERAGE(B1:B7)
Then highlight from D17 (D16 are blank and D7 has the formula)
Click on the fill handle and drag down as far as needed.

As for the other bit about deleting posts, if your newsreader is Outlook
Express, just click on the post and go to Message>Cancel Message
there should be something similar in other newsreaders.

HTH
Martin

 

[Dave Horne]

It's quite possible I'm dense, but what I see now (and in every D cell), is
an average for the last seven days.

Cell D5 diplays =AVERAGE(B5:B11) and cell D6 displays =AVERAGE(B6:B12)
and so on.

What I was hoping to see, six empty D cells and every 7th cell would contain
the previous week's average.

So, I do have the information I need, I just now need to 'pick' the results
of every seven D cells.

Thanks, Dave Horne

 

[MartinW]

Dave you didn't follow the instructions.

D16 are blank
put the formula in D7

Then highlight from D17 ( all seven cells are highlighted)

Then click on the fill handle and drag down as far as you need.

HTH
Martin

 

[Dave Horne]

Martin, thanks for your perservance. I got it! (I now entered the
forumla in the 7th cell, dragged up, and then dragged all the way down.)

Thanks, Dave Horne