|
Answer» 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
BWhenever 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
|
