Excel Calculation

[BLRingler]

Hello, Please move if in wrong forum

How do I calculate monthly averages over a year to a know amount?

I know I have to install 7300 computers over 12 months. How do I add each month to a total and calculate each months % towards the total?

The 12 months are not even divided same.  (7300 / 12 = 608 computers a month) but what if I did 3 computers one month and 1200 another month?  I need to calculate each month towards the 12 month total of 7300?

Thanks
B

[rjbinney]

Whenever I need Excel help, I post in mrexcel.com's forums (fora?). Usually I get an answer in less than ten minutes.

If I understand your concern correctly, it should be pretty straight forward.

Column A = Month
Column B = Manually Enter, number of computers added
Column C = Running total of added computers (so, Cn=B1 + Cn-1)
Column D = Remaining installs (not necessary but maybe nice to know?) (so, Dn=7300-Cn)
Column E = Percent complete (=Cn/7300)

Sample Spreadsheet: https://1drv.ms/x/s!AiFxUE6rh56W5gNu8pd1vWMHFOj2