For convenience, the category values in column B are in thenamed rangecategory(B5:B122).
To generate the count, we use theCOUNTIF function.
The formula in H5 is:
On the left, COUNTIF is configured as explained above.
For example, 65% is read as “Sixty-five percent” and is equivalent to 65/100 or 0.65.
Accordingly, the values in column H aredecimal values, with thePercentage number formatapplied.
Pivot table option
Apivot tablewould also be a good way to solve this problem.
COUNTA does not count empty cells.
