Hi,

Try this array entered formula

=AVERAGE(IF(ISNA(B1:B7),"",B1:B7))

being an array you must enter it by pressing Shift+Ctrl+Enter

In 2007 you can use

=AVERAGEIF(B1:B7,"<9E9")


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Tuan" wrote:

How do I ignore "#N/A" data in a column while calculating average