I am sure that this is a pretty simple one for those that know how, but I am really struggling.
I need to maintain a running percentage for the year where each quarters completed totals are entered. The columns that I have set up are:
A1-Years Target, B1-Q1 Actual, C1-Q2 Actual, D1-Q3 Actual, E1-Q4 Actual Completion, F1-Completion %
Really appreciate any help,
Thanks in advance
In F2 (formatted as percent), then copied down:
=IF(A2="", "", SUM(B2:E2)/A2)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the speedy reply Jerry, really helpful and has solved my first problem.
The next one that I have is if the same columns contain a running total, so where the target for the year is 50, in each quarter ther figure is a running total so far, eg Q!=10, Q2=25, Q3=42, Q4=49.
How do I get the completion percentage to give me a running update?
Hope that makes sense!
Then maybe:
=IF(A2="", "", MAX(B2:E2)/A2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks