Formula/Calculation question

[Tmlthe]

Hello,

I am creating a Balanced scorecard, with 12 columns, each represents one month Jan - Dec. At the end is a column for the total. What I would like to achieve is for excel to recognise that let's say we are only in August and it should devide the total only by 8 to receive the current average, then in September by 9 and so on.
I am grateful for any suggestions?

regards
Tim

 

[T. Valko]

Hello,

I am creating a Balanced scorecard, with 12 columns, each represents one month Jan - Dec. At the end is a column for the total. What I would like to achieve is for excel to recognise that let's say we are only in August and it should devide the total only by 8 to receive the current average, then in September by 9 and so on.
I am grateful for any suggestions?

regards
Tim

Maybe something like this...

=Total/MONTH(NOW())

 

[Tmlthe]

Thank you for your answer but it didn't work however it gave me a idea. What I did now is put =TODAY() in one cell let's say B3 and then in B4 =MONTH(B3) which gives me the number. At the end I put SUM(Range)/B4 which is exactly what I need.
Thanks for the input

 

[dbn]

I'm probably missing something, but doesn't =AVERAGE just do this anyway?

It doesn't count empty cells, so would only count up to August, or whatever.

 

[Tmlthe]

perfect, even better.
Thank you

 

[T. Valko]

Thank you for your answer but it didn't work however it gave me a idea. What I did now is put =TODAY() in one cell let's say B3 and then in B4 =MONTH(B3) which gives me the number. At the end I put SUM(Range)/B4 which is exactly what I need.
Thanks for the input

In my reply "Total" is a placeholder for your total formula/cell.

The MONTH(NOW()) bit will do the same thing as:

What I did now is put =TODAY() in one cell let's say B3 and then in B4 =MONTH(B3) which gives me the number.

Without having to use cells.