Try this:

=ROUNDDOWN(IF(COUNT(K40:K45),AVERAGE(K40:K45),0),0 )

Returns 0 if the range doesn't contain any numbers.

Biff

"Bob Smith" wrote in message
ink.net...
Hi folks, within another workbook, I track game data for our team. I have
a few columns where games have yet to be played and am showing the
following above error message as there is no data in the columns. Formula
I'm using is - =ROUNDDOWN(AVERAGE(K40:K45),0) .

Any suggestions on modifications so that I don't show the error message,
other than just changing the font to white font?

TIA,

Bob