I think you meant COUNT. COUNTA will also count non-numbers.
Jerry
Gary Brown wrote:
Use the worksheet function CountA
HTH,
Gary Brown
"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
|