Blank cell with average formula

[Scoober]

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(D2630) 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 D2630?

Thank you for you help in advance.

 

[Jacob Skaria]

=IF(COUNT(D2630),AVERAGE(D2630),"")

If this post helps click Yes