=AVG function

ginamt3

I'm trying to get an average sales total for 2020. We are only on week 7 but it counts ALL 52 and averages it out. How can I get the function to work so it only averages the current week and prior weeks?

ron.judenberg112096

on the first column put the week number

in the second column put weekly sales

for the average (YTD) =AVERAGEIF(Week1:Week5, <WEEKNUMBER(TODAY()), Sales1:Sales5)

ron.judenberg112096

on the first column put the week number

in the second column put weekly sales

for the average (YTD) =AVERAGEIF(Week1:Week5, <WEEKNUMBER(TODAY()), Sales1:Sales5)

ginamt3

Thank you!