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