Thank you. Debra.
-----Original Message-----
Dear all,

I have rows of numbers which I need to average. The
trouble is not all entries are numbers. I only want to
average the numbers present. I have:

SUM(A1:A20)/COUNTIF(A1:A20, ?)

I get stuck on the criteria. How do I say in excelspeak
"is a number"?

regards

Debra
.