how can I get the average without #DIV/0

[carloslp]

How do I get an average in I have #DIV/0!
ex:

A
5
#DIV/0!
6
4.5
= Average, with out copunting that number....

#DIV/0! is a result of a formula taht is =IF(WEEKDAYS(Calculation!$B10)=6;AVERAGE(Calculation!C4:C10);"")

[Ron Coderre]

Here's one way:

=SUMIF(A1:A4,"<>#DIV/0!",A1:A4)/COUNT(A1:A4)

Regards,
Ron

[Domenic]

Another way would be to avoid the error in the first place by replacing your formula with the following...

=IF(WEEKDAYS(Calculation!$B10)=6;IF(COUNT(Calculation!C4:C10);AVERAGE(Calculation!C4:C10);"");"")

Hope this helps!