Using Countif in Excel to find the value A*

[Chris559]

Being a teacher I often use the mark A*, but trying to count this value in Excel is not easy. The asterisk is giving me a problem. I have used ~ before, but cant get this to work either. Any suggestions?

 

[GHolden]

Hi,

I use =COUNTIF(A1:A23,"A~*")

Works fine for me...

There are two ways to write error-free programs; only the third one works.

 

[GHolden]

If the A* is the only 2 char value in the column you could use

=COUNTIF(A1:A23,"??")

Which would ignore A, B, C, etc. But wouldn't work if you use D-, A+, etc

There are two ways to write error-free programs; only the third one works.

 

[Chris559]

Thanks - Have now got it to work. I had the ~* round the wrong way!