Hi,
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(
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(