Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count formulas between excel files | Excel Worksheet Functions | |||
Count formulas | Excel Discussion (Misc queries) | |||
count formulas | Excel Discussion (Misc queries) | |||
Using count formulas with '<=' | Excel Discussion (Misc queries) | |||
Count IF Multipile Formulas | New Users to Excel |