Hi Debra,

Use the built in Average function which ignores non-numerical values.

---
Regards,
Norman



"Debra" wrote in 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