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.