Count Formulas

  • Thread starter Thread starter Jeff
  • Start date Start date
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
 
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.
 

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 do a formula counting the number of hours between 2 times? 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Count specific text only if adjacent cell is blank? 3
count total dates for each month 2
counting colored cells 3
How to count the time? 1
Count Formula Need Help! 1
Need Help with Formula 2

Back
Top