Running Averages

  • Thread starter Thread starter tim
  • Start date Start date
T

tim

Hi (again),
I have an application that I need to calculate a running monthly
average based on the amount in the "YTD Total Cell" The following
formula (found in archives) seems to work, but my problem is ( other
than I don't completly understand the equation) is that my fiscal year
goes from Jul - Jun, so when this equation computes the averages, it's
incorrect.

Here is the equation I'm trying to modify

=IF(MONTH(TODAY())=1,0,A1/(MONTH(TODAY())-1))

tks

Tim
 
Tim

I think I've got the timings right.

=$A$1/IF(MONTH(TODAY())-1<7,MONTH(TODAY())-1+6,MONTH(TODAY
())-1-6)

Tony
 
That worked!
I believe if I understood the equation correct. If I remove the -1 in 3 places,
it will include the current month as well? This shoild give me a more accurate
running avg.

tks
again!

tim
 
Back
Top