Forum Discussion
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...
It's better to use Excel Table, average will be automatically updated with adding rows to the table.
Otherwise that could be average on dynamic range which could be returned as A1:INDEX(A:A, COUNT(A:A)). This one only illustrates the approach, concrete formula depends on how your data is structured.