Counting numbers in a column without including others

[kim11757]

I have set up a time sheet (see below) I am trying to count the total of
times tardy in a column but not include the vacation, personal, sick days:

Anna
855
In
personal
sick
950
As you can see she was late two days. I only want to count those two days

[Dave R.]

What makes her late? Do you start at 8?

You can use a formula to count numbers greater than 800.

=SUMPRODUCT(--(A1:A10>800),--ISNUMBER(A1:A10))

I would reccomend that you stop what you're doing and take another look at
how you're organizing that data. You'll have a tough time summarizing,
averaging, etc. if you do it that way.



"kim11757" <[email protected]> wrote in message
news:[email protected]...
> I have set up a time sheet (see below) I am trying to count the total of
> times tardy in a column but not include the vacation, personal, sick days:
>
> Anna
> 855
> In
> personal
> sick
> 950
> As you can see she was late two days. I only want to count those two days