Calculating percentage complete of task list

lja

New member
Joined
Mar 21, 2014
Messages
1
Reaction score
0
Points
0
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:
Capture.PNG

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
 

Attachments

  • Capture.PNG
    Capture.PNG
    16 KB · Views: 46

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Just use

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