How do I count how often a text or number appears in entire worksh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet of scheduled hours:

Sun Mon Tue Wed Thu Fri
off v v 6a^1 7a^2 v
v 8a^3 8a^3 8a^3 8a^3
MD1 MD1 MD1
AM*C* MD1 AM1 AM*C* MD1

How can I get the number of times, for instance, v appears?
 
Something like:

=COUNTIF(A1:F5,"*v*")

will count cells containing a v

=COUNTIF(A1:F5,"v")

will count cells having only a single v in them and nothing else
 
Back
Top