Which formula to use when i want to have return a value based on a range of cells having a value

I need to return a value of ytd sales averages from a range of cells that may have data entered. currently in week 43 so weeks 1-42 will have data entered, i want to show the ytd average of these cel...