dont want #DIV/0!

[lprenrut]

Hi all

Probably easy if you know but I dont, can someone help,here goes

In cells B4:B10 I have numbers 1,2,3 etc...

In cell B11 I have an average of these cells B4:B10

Problem I'm having is if all cells from B4:B10 are blank B11 returns #DIV/0!

I just want B11 to remain empty when cells B4:B10 are blank


Thanks

lprenrut

 

[lprenrut]

VoG

Thank you it works

lprenrut