Average if the cell content is a number

[22strider]

Hi

I have a list that contains numbers and some text values. I want to calculate average of the numbers in the list (leaving text out ofcourse). I've been trying many things like SUMIF()/COUNTIF(); but I can't make it work.

I am using Excel 2003

Thanks
Rajesh

 

[barry houdini]

Hello Rajesh,

A regular AVERAGE function will ignore text values in a range so you should be able to use a formula like

=AVERAGE(A1:A10)

 

[22strider]

Thanks; I didn't realize that excel ignored text values. Thanks again
Rajesh