Trying to count the number of times a "type" of value occurs

  • Thread starter Thread starter astiller
  • Start date Start date
A

astiller

I am wanting to track the number of times a test is run. My spreadshee
layout is: Column A will hold dates and Names (A6 - Date1 , A7
Name1, A8 - Name2, A9 - Name 3, A10 - Date2, A11 - Name1, A12 - Name2
A13 - Name 3, A14 - Date 3, etc...)

I want to count the number of times the date appears. The test is ru
on different days. The COUNTIF function does not work becuase th
criteria is to spcific. How do I get excell to count the number o
times the type of field is seen rather than the vaule of the field.

Ala
 
No. of times a date appears:

=COUNT(A6:A14)

No. of times a name appears:

=COUNTIF(A6:A14,"*")

HTH
Jason
Atlanta, GA
 

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

Maximum Number of Blank Cells between Non Blank Cells in a Range 5
Counting number of times name occurs between two dates 2
Counting the number of times a character occurs in a cell 1
How to count the maximum number of consecutives? 9
Counting number of occurances of a word 5
Returning other cells with the same value in a column, but different row. 1
help with datedif function please 4
Count number of occurences in a list 12

Back
Top