Thread: Average out a total starting with 0

Hi

New to excel

I have a year end total

How do I spread the total across the year starting Jan with 0 and the number growing to meet that total at year end.

many thanks in advance

josa

Please post a sample workbook

sorry did not look right see attached

Hi, maybe:
=($M$2/11)*(COLUMN()-2)

or in C2 and drag to copy:
=B2+($M$2/11)

May thanks

that will do it

again many thanks

josa

No problem.
By the way, if you want the calculation to adjust for day of month (in C2):
=($M$2/($M$1-$B$1))*(C1-$B$1)