Solved - Ignoring the #DIV/0! Error in a range

[wwsd]

I'm trying to average a column range range =AVERAGE(A5:A29) that has blank cells not yet populated and also cells with formulas that contain the #DIV/0! error.

Obviously the cell with my formula produces the #DIV/0! error when it tries to average this range. Can someone point me in the right direction so the formula =AVERAGE(A5:A29) will work?

[daddylonglegs]

It might be better to get rid of the #DIV/0! errors, what formula produces those?

Otherwise try this formula to average

=SUMIF(A5:A29,"<>#DIV/0!")/MAX(1,COUNT(A5:A29))

[wwsd]

It might be better to get rid of the #DIV/0! errors, what formula produces those?

Otherwise try this formula to average

=SUMIF(A5:A29,"<>#DIV/0!")/MAX(1,COUNT(A5:A29))

Those are pasted links from cells from a date range that has not been popultated yet. I think there is a way to hide those by using a hidden column next to it with another formula in it. My next project.

Thanks for your help tonight. Gotta learn to do this stuff myself.

Steve