week end and week so far results formular in % format

  • Thread starter Thread starter happyhammer
  • Start date Start date
H

happyhammer

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.
 
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.
 
Jim Thomlinson said:
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.
Click to expand...
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
 
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.
 
Back
Top