Formula to return fraction that represents the number of cells that meet certain criteria
I'd like to return a fraction such as 3/4 to show the number of cells that meet certain criteria. If it returned 3/4 that would mean 3 out of 4 cells met the criteria.
Currently, I'm using a percentage rating, but in my opinion, if you don't have at least 10 cells to evaluate, the percentage rating value isn't true in the scenario I'm using it in.
Help Article Resources
Check out the Formula Handbook template!