Hi, is there a way to format cells so that they cannot be left blank, so that one HAS to make a selection during data entry?

Hi, does anyone know how to create a formula which will allow me to average the numbers in columns ignoring zeros and/or blanks? Thanks, Rowan