Hi,

How can I leave a answer cell blank if the range of cells I am using to get
an average answer are blank?

i.e. I am using this formula =AVERAGE(D26:D30) in D31. What formula do I use
if I wish this formula to work but leave a blank cell of there are no numbers
in D26:D30?

Thank you for you help in advance.