I am having trouble with this particular formula, I am not too sure, as it does work on another area of my spreadsheet.

Criteria,

A B

1 Health Dental

2

3 F S

4 SpEx SpEx

5 S S

6 F F

7 F F

=countif(A3:A7,"f")

=countif(A3:A7,"s")

because i have the SpEx in there it is not working. If I take it out the formula works just fine? Is there a way around this?

formula is, countif(