View Single Post
  #5   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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