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

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i find data from worksheets in excel 1
count conditional days - ajit 6
How do I add a list of numbers in a colum that = a repeating word. 2
Count working days by week 7
How Do I Count This LIst? 2
How do I count the times a number appears in a table using criteri 4
COUNT function - # of occurences a number appears in all cells 26
Data selection from one worksheet into a second worksheet. 1

Top