week end and week so far results formular in % format
 

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.

week end and week so far results formular in % format
 

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.

week end and week so far results formular in % format
 

"Jim Thomlinson" wrote:

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.
Hi

Id be looking for 75% of the 2 results but would need the next 3 cell to be
empty and not afecting the result ive tried
=averagea(A1:E1) which only gives me a result if all data is inputed but if
empty is useing the 5 cells at 20% of each result which i dont want

week end and week so far results formular in % format
 

Don't use AVERAGEA, as it will include text as 0. The normal AVERAGE function
will ignore blank cells, or formulas that evluate to "", thus not distorting
your results.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"happyhammer" wrote:


"Jim Thomlinson" wrote:

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.
Hi

Id be looking for 75% of the 2 results but would need the next 3 cell to be
empty and not afecting the result ive tried
=averagea(A1:E1) which only gives me a result if all data is inputed but if
empty is useing the 5 cells at 20% of each result which i dont want