Formula to return fraction that represents the number of cells that meet certain criteria

Shelby

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.

Jeff Reisman

Try one based on this:

The COUNTIF statements count each cell that equals A, the JOIN converts the value to text, the second JOIN concatenates a "/3" at the end (3 being the number of cells you're counting.)

This makes it easier to see the targets of the cell references:

Shelby

@JReisman27 thanks for the response. Shortly after I submitted my question I figured out a solution. Here's the formula I used:

=COUNTIF([Toolbox Talks are completed & available for review]@row:[All Superintendents are OSHA 30 certified]@row, "Yes") + "/" + COUNT([Toolbox Talks are completed & available for review]@row:[All Superintendents are OSHA 30 certified]@row)

Jeff Reisman

@Shelby Cool! That solution seems a bit more elegant than mine!