Average determination

[Debra]

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

 

[Gary Brown]

Use the worksheet function CountA
HTH,
Gary Brown

 

[Norman Jones]

Hi Debra,

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

 

[Guest]

Thank you. Debra.

 

[Jerry W. Lewis]

I think you meant COUNT. COUNTA will also count non-numbers.

Jerry