I have a column of text based codes. Some end with F, some with A and some with - .
A11 Top MPEF
I would like to be able to count how many end with F.
I have tried a number of variations suce as:
but they do not work.
=countif(A1:A12,"W.") works, returns 1
Please note that the formulae include the wildcard asterix but they don’t seem to show up on this blog.
Any help would be great.