Count Formulas

J

Jeff

Hi, Question - I am working with a work schedule that list employees with the
hours they are working. Most of the cells have the start/finish times but
there are some that have VAC which I do not want to count along with any
blank cells. I just want to count cells that have the start/finish times.
jeff
 
G

Gary''s Student

A lot has to do with how the data is organized in rows and columns, but, for
example, say column A has a mixture of start times, stop times, VAC, and
blanks.

The formula:

=COUNT(A:A) will count the times and exclude both text (like VAC) as well as
blanks.
 
Top