Computing averages excluding values with no value

J

j_jimenez420

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.
 
T

Toppers

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