Running total as a percentage

Closed
Mel - Oct 12, 2009 at 06:59 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 12, 2009 at 11:39 PM
Hello,
I have a group of employees that must complete training. They are listed in a column. As each employee completes the training I will enter an "x" in the column next to their name. At the bottom of the column I want to show a running total displayed as a percentage of employees that have completed the training...so I need to display the total of nonblank cells in a column as a percentage?? Very simple but I haven't worked with Excel much recently. Help!
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 12, 2009 at 11:39 PM
=countif (range,"x")/count(range)
this format as percentage
can you design this formula

range is the range where the data is
0