Hi there. Can anyone please tell me how i can take an average from one week,
and add it to the next average for the following week on a new sheet to work
out an overall average of the set amount of weeks?

And also is there a way of automatically regenerating a sheet on a weekly
basis please?

I think you need to provide more detail. What are you averaging? What
is your result? Is it a number or a percentage? If it's a percentage,
based on what?

Then it's a question of what level of math would give you the result
you want.

If for instance, if your "average" is a simple number, then you have to
ask if you are OK with simply taking the "average" number from each
week, adding them up, and dividing by the number of weeks. OR Do you
need to add up the total "volume" for all weeks and divide by the
number of weeks?

If what you are looking for is based on percentages, you should do a
weighted average which would be done by multiplying each volume by its
percentage, adding all those values, and dividing by the total volume.

More info please.

Regards,
Jamie


phildav wrote:
Hi there. Can anyone please tell me how i can take an average from one week,
and add it to the next average for the following week on a new sheet to work
out an overall average of the set amount of weeks?

And also is there a way of automatically regenerating a sheet on a weekly
basis please?

Thanks for replying Jamie.

The averages are numbers. It's average scores within a darts league. The
players averages are worked out each week and just wanted to work out the
seasonal average as I go along. I am satisfied with just taking the
"average" from each week to work out the seasonal average.

many thanks
Phil


"jseven" wrote:

I think you need to provide more detail. What are you averaging? What
is your result? Is it a number or a percentage? If it's a percentage,
based on what?

Then it's a question of what level of math would give you the result
you want.

If for instance, if your "average" is a simple number, then you have to
ask if you are OK with simply taking the "average" number from each
week, adding them up, and dividing by the number of weeks. OR Do you
need to add up the total "volume" for all weeks and divide by the
number of weeks?

If what you are looking for is based on percentages, you should do a
weighted average which would be done by multiplying each volume by its
percentage, adding all those values, and dividing by the total volume.

More info please.

Regards,
Jamie


phildav wrote:
Hi there. Can anyone please tell me how i can take an average from one week,
and add it to the next average for the following week on a new sheet to work
out an overall average of the set amount of weeks?

And also is there a way of automatically regenerating a sheet on a weekly
basis please?