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

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
 
J

Jason Morin

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

how to use an formula to transpose a list(left) to be like the right? 2
Maximum Number of Blank Cells between Non Blank Cells in a Range 5
Counting the number of times a character occurs in a cell 1
Counting number of times name occurs between two dates 2
Count the number of times a name occurs in a column 2
Trying to count the number of times a name appears / table 4
How to count the maximum number of consecutives? 9
Need to Count the number of times a value occurs within a dt range 9

Top