ExcelBanter - Count Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/206120-count-formulas.html)

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

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