I'm assuming you mean this happens when *none* of the cells contain data. If
*any* cell contained data it should work (as long as there are no error
values in the range) and AVERAGE would ignore the empty cells and text.
Try this:
=IF(COUNT(D33,G33,J33,M33,P33,S33,V33,Y33),AVERAGE (D33,G33,J33,M33,P33,S33,V33,Y33),"")
--
Biff
Microsoft Excel MVP
"Security Dave" <Security
wrote in message
...
I am trying to formulate a cell to figure averages from cells that have
averages.
My current formula reads
=AVERAGE(D33,G33,J33,M33,P33,S33,V33,Y33)
I am getting the error due to blank cells that have not been filled in
yet.
Any suggestions?