calculating data in a column, while ignoring cells with text in them.

I have a column where some cells have numbers and some have text.

ie.

column 1
10
5
200
VACATION
25

I want the equation to find the average of the numbers by totaling and dividing by the total amount of numbers... So in the above example, since the word "vacation" is in one of the cells, it should not count that.. so the equation would add up 10, 5, 200, 25 & divide by 4.

but if vacation was actually a #... it would add up and divide by 5 automatically.
It's a simplified version of what i'm doing, but if I can figure this out to make it do it automatically, I will be able to apply to what I"m doing.

hope this makes sense.
thanks
J.

well i guess i should have been more specific... i don't really want to find the average, but thought that finding out how to do a calculate without adding in cells with "words" would help me... so here's what i'm trying to do.


im trying to find the productivity of each staff member.. each day has 480 minutes so if they have minutes for mon - fri as the following:

mon: 25
tue: 25
wed: vacation
thurs: 10
fri: 25

I want to be able to add the numbers (in this case: 85), than divide by 480*4 (since 4 is the number of days they worked. as they had one vacation day)
but if the employee did not go on vacation.. it should divide by 480*5.

so basically.. I want to be able to add all the numbers in any given week.. then divide by 480* the numbers of days they worked (or the # of days that don't say "vacation" or "sick".)

I hope this gives more info.

thanks in advance

J>

Thank you so much... Your response gave me the idea I needed... I appreciate it.

J.