Norman -

Thank you for the reply. Yes I realize this. But for instance in a large worksheet/workbook where some cells that are to be averaged may not be populated yet (due to awaiting a calculation from another field) then until there is at least 1 value ready the cell we are trying to create for this example displays "#VALUE!". We would like to not have numerous cells display this while they await other data so we had hoped to use a calculation that would allow "" to be displayed if all the cells to be averaged were aslo displaying ""

Any further thoughts?