Thread: How do I count how often a text or number appears in entire worksh
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I count how often a text or number appears in entire worksh
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


--
Gary''s Student - gsnu200748


"willwork4food" wrote:

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?


Reply With QuoteReply With Quote