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

Counting the Number of times the Slides are visited 0
Counting the number of times a character occurs in a cell 1
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Find a number in a column then return a value from another cell 2
Counting number of times name occurs between two dates 2
Function in Excel to count and list number of entries of text valuesin a row. 2
count if equals first non error cell 6
Count if equal to first non error cell 0

Top