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!

    Hi,

    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: 784
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?
    Thanks
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

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

  2. #2
    Just use

    =COUNTIF(B2:B19,"y")/SUM(COUNTIF(B2:B19,{"y","n"}))

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
  •