Replacing Div/0 result

[Celticguy]

Afternoon,

New user with a problem here.

I'm responsible for a spreadsheet with has the following formula

=IF(COUNTA('01:31'!B11)=0,"",AVERAGE('01:31'!B11))

We have several entries at that bringing back a Div/0 result which I would like to replace with a simple 0. The same cell has the maximum number of Conditional formats.

Can anyone point me in the right direction to make this work as the Div/0 result is impacting other results.

Any help would be appreciated.

[Andrew-R]

If you're using Excel 2003 then try this:

=IF(COUNTA('01:31'!B11)=0,"",IF(ISERROR(AVERAGE('01:31'!B11)),0,AVERAGE('01:31'!B11))

[zbor]

Try:

=IF(COUNT('01:31'!B11)=0,0,AVERAGE('01:31'!B11))

[Kramxel]

---

hmm.. please correct me if i'm wrong but wouldn't averaging cell b11 across multiple pages produce incorrect results if a DiV/0 error is changed to 0..

wound't the below provide a more accurate result?

Please Login or Register  to view this content.

[Celticguy]

Zbor's result has done the trick perfectly. Due to the nature of the result, it's worked a treat

Thank you guys