Try something like this:

For values in A1:A10

B1: =SUMIF(A1:A10,"<#VALUE!",A1:A10)/COUNT(A1:A10)

or...perhaps....

B1: =AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))
Note: For that array formula, hold down [Ctrl] and [Shift] when you press
[Enter].


Does that help?
Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Robin" wrote:

I have a column of calculated values (time). In that column, there are a few
#VALUEs due to unavailable data for that particular cell. How do I average
the column, but not include cells with #VALUES in the average? I also need
zero included in the average. eg, my column, B1:B4 consists of:
0:02
0:04
#VALUE
0:00

I would like the average to return a value of 0:02 ((0:02 + 0:04 + 0:00)/3)

Thanx