Settting aside that you shouldn't really be taking an average of an average
try this

=SUM(D33,G33,J33,M33,P33,S33,V33,Y33)/COUNT(D33,G33,J33,M33,P33,S33,V33,Y33)

Mike

"Security Dave" wrote:

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?