Averaging with empty cells

[benjamings]

Hi, I want to create averages of multiple cell. In some rows, all columns have data and I get my average. In other rows, some columns contain data and others don't. In that case, Excel still gives me the right average and it ignores the empty cells (which is what I want).
However, when I have a row where all cells are empty, Excel gives me the message #DIV/0!
But I want the cell to be empty.

I tried the following formula:
=IF((B1:E1)="", "", AVERAGE(B1:E1))

But then I get "#VALUE!"

Now I wonder where the error is and how I can fix it.

Best
Benjamin

[DonkeyOte]

Given your use of XL2007

=IFERROR(AVERAGE(B1:E1),"")

Else

=IF(COUNT(B1:E1),AVERAGE(B1:E1),"")

[benjamings]

Perfect. Thanks