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:
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
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:
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