I have a report that shows the activity of a program month over month. The program will run for a certain period of days (EX: 150 days). I update the report each month and need to have a cell that show how much of the program has been completed to date in the form of a percentage. Any thoughts?
Hi,
I'm assuming you want to count cells no of cells complete.
You can use this formula
=COUNTA(H:H)
If you have a header then use
=COUNTA(H:H)-1
The below will ignore header and if formatted as Percentage will show the % or you have 150 entries
=(COUNTA(H:H)-1)/150
or you could use this to show if your project has overran
=IF((COUNTA(H:H)-1)/150>=100%,"Project Overran",(COUNTA(H:H)-1)/150)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks