Computing averages excluding values with no value
 

I am trying to figure out an average for a range of cells but I do not want
the cell used in the calculation if there isn't a value. I am using it for
YTD (year to date) averages and do not want to have to go and change it after
every month. Any help would be greatly appreciated.

Computing averages excluding values with no value
 

AVERAGE ignores blank cells (but includes cells with zero) so if the cells
are blank, you can AVERAGE the whole of your range.

"j_jimenez420" wrote:

I am trying to figure out an average for a range of cells but I do not want
the cell used in the calculation if there isn't a value. I am using it for
YTD (year to date) averages and do not want to have to go and change it after
every month. Any help would be greatly appreciated.

Computing averages excluding values with no value
 

Thanks! Looks like I am just overthinking again. Appreciate the help!

"Toppers" wrote:

AVERAGE ignores blank cells (but includes cells with zero) so if the cells
are blank, you can AVERAGE the whole of your range.

"j_jimenez420" wrote:

I am trying to figure out an average for a range of cells but I do not want
the cell used in the calculation if there isn't a value. I am using it for
YTD (year to date) averages and do not want to have to go and change it after
every month. Any help would be greatly appreciated.