So you end up with 5 cells each containing a percentage. That seems fairly
straight forward. Now you wnat to know how do you get the Week to date
percentage. Now that depends on how you want to calculate the percentage. Is
it the average of the percentages or is it based on the souce data... here is
an example with just 2 days.

100 100 100%
500 1000 50%

The rows generate 100% and 50%. tahe average of those 2 is 75%. However if I
add up the values from the source I get

600 1100 55%

What number were you looking for. 75% or 55%?

Can you tell I'm an accountant.

--
HTH...

Jim Thomlinson


"happyhammer" wrote:

Hi im trying to find /maka a formula for 5 cells with data in which is
percentage but in 6th cell i want to create a week so far percentage result
that adjust each day data is inputed any ideas im very novice at this.