View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j_jimenez420 j_jimenez420 is offline
external usenet poster
 
Posts: 1
Default 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.