I have all of my week dates for all of 2025 in Row 7 and all of my week numbers for 2025 in Row 6. In F1 is the beginning week number (currently is '6')to pull average then in F3 I have the week number to average until (currently is '8'). The Row to be averaged is 22.
So, I want to average the percentages (In Row 22) that fall between week 6 and 8 (these will be numbers that can be changed by the user to get the data from the week numbers that they'd like to see). If I change the start and end week numbers to say 10 and 15, then I want only those week numbers to be averaged from row 22.
I hope I have explained it properly.
So, I want to average the percentages (In Row 22) that fall between week 6 and 8 (these will be numbers that can be changed by the user to get the data from the week numbers that they'd like to see). If I change the start and end week numbers to say 10 and 15, then I want only those week numbers to be averaged from row 22.
I hope I have explained it properly.