Thx for the quick reply, but this is not the solution to my problem I'm
afraid (or I simply don't get it ).
I try to get the average of a row, in that row there can be several #div/0!
errors. Not just one. I tried =IF(C1:D1="","",C1/D1) but that didn't work as
well.

"Gary''s Student" wrote:

Instead of something like:

=C1/D1
use
=IF(D1="","",C1/D1)

The #div/0 errors will vanish and the average will be over the available
values.
--
Gary''s Student - gsnu200757


"nagje" wrote:

Hey there,

I'd like to get the average of a row filled with percentages. But because
the percentages will only be filled in when the month has started I have some
div/0! values. How can I calculate the average? And please try to keep it
simple :D

Hope I explained it clearly, if not let me know, see an example below.
thx
Nagje

example (yes i know this isn't a row ;-) ):
Jan 95.2%
Feb 100.0%
March 93.2%
April 95.0%
may 96.9%
June 97.6%
July #div/0!
Aug #div/0!
Sept #div/0!
Okt #div/0!
Nov #div/0!
Dec #div/0!

Average year = ???????