If function within Excel

Hello Michelle

Thank you for your question.

I think that COUNTIF would work for this.

To count the number of times H appears:
=COUNTIF("H",range) where range refers to the cell range within which you would like Excel to count the number of times H occurs.

The same should work for counting the number of times S appears, if you replace "H" with "S" in the above formula.


Kind regards
Amanda