Average formula

[nevans1283]

I need to create a formula that will average only the cells that contain a value in a range of cells.  Each of these cells contain a formula that pulls data from a different worksheet, so until those corresponding cells are populated, these cell contain "#DIV/0!". I hope that makes sense!

[#2]

If your range is Column B, you may use this formula:
=AGGREGATE(1,6,B:B)