One way:

=AVERAGE(A1:A3)


AVERAGE() ignores text.

If you may not have ANY numeric values in A1:A3, then perhaps:

=IF(COUNT(A1:A3),AVERAGE(A1:A3),"No Values")

In article ,
Arne Hegefors wrote:

Hi! In column A I have values in some cells and "#MISSING!" in some cells.
In column B I want to calculate the average value of e.g. A1 to A3. How can I
do that when some values are missing? Thanks!