ExcelBanter - Blank cell with average formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Blank cell with average formula (https://www.excelbanter.com/excel-worksheet-functions/238727-blank-cell-average-formula.html)

Scoober

Blank cell with average formula

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.

Jacob Skaria

Blank cell with average formula

=IF(COUNT(D26:D30),AVERAGE(D26:D30),"")

If this post helps click Yes
---------------
Jacob Skaria

"Scoober" wrote:

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.

All times are GMT +1. The time now is 07:08 PM.