Results 1 to 2 of 2

Thread: Calculating percentage complete of task list

  1. #1

    Calculating percentage complete of task list

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I've not used Excel for much more than simple graphs before. What kind of formula or formatting do I need to calculate a percentage of tasks complete?

    Here is an example of what my excel file looks like:
    Name:  Capture.PNG
Views: 1034
Size:  15.9 KB

    I have conditional formatting that changes the background colour depending on whether or not the cell contains "y" or "n".
    I would like to be able to have a percentage displayed at the bottom of the number of "y" cells.

    How would I go about doing this?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	42 
Size:	16.0 KB 
ID:	2157  

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Just use


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts