Hello

I have looked through the Excel posts but could not find an answerto the
following question. I would be grateful for any help.

I would like a formula that will display the average of columns A:C in
column D. This works fine if there are values in columns A:C, eg
5.0+5.0+7.0=5.6

If, however, the cells in A:C are blank, #DIV/0! is displayed.

A B C D
5.0 5.0 7.0 5.6
4.5 4.5 5.0 4.6
#DIV/0!

I would like column D to be blank if A:C are blank
& if values are displayed in A:C for the average value to be displayed in
column D.

I am using Excel 2000.

Many thanks.

Rachael