How to display a cell with a countifs formula as a percent?
I have one cell that has a COUNTIFS formula to count the total number of projects and another cell with a COUNTIFS formula to count the number of projects that will be complete by October 27th. I don't actually want a count of projects complete by 10/27 I need a percent. Can I divide the count in cell 2 / count in cell 1? Or do I have to do that in a third cell?
Help Article Resources
Check out the Formula Handbook template!