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.