How to display a cell with a countifs formula as a percent?

Aspen26

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?

Paul Newcome

You can do that in a single cell.

=COUNTIFS(.......) / COUNTIFS(.......)