Thread: Count Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Count Formulas

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.
--
Gary''s Student - gsnu200806


"Jeff" wrote:

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