formulas

[Guest]

I am puting an estimated budget together in excell.
I have the yearly estimated totals so I need the formula to divide the total
back into each month.
sample:
jan feb mar apr may jun jul aug sep oct nov dec total
12 24 36 48 60 72 84 96 108 120 132 144 144

Thanks,
Rmoor

 

[Myrna Larson]

Do you mean you want the amount for each month as a percentage?

=A2/$M2 and copy to the right.

 

[JulieD]

Hi Rmoor

if i'm understanding you correctly and your workbook is set up with the
months starting in B2 and going to M2, put the total in N3
then in B3 type
=$N3/12
in C3 type
=INT($B3*COUNTA($B$2:C$2))
(watch the $ they need to be in these spots)

the formula can then be dragged across (fill handle, bottom right of cell)
to M2 and down as far as you like

Cheers
JulieD