Thread: [Solved] Variable data set in Average formula
View Single Post
 
Old 09-16-2017, 05:12 AM
Filip88 Filip88 is offline Windows 10 Office 2016
Novice
  
Join Date: Jan 2017
Posts: 12
Filip88 is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
You do not say where the range should begin. Should it always start in A2 ?
Then =AVERAGE($A$2:INDEX($A$2:$A$12;C2))
It should start in A2 but the formula should affect whole range, i mean if i copy AVERAGE($A$2:INDEX($A$2:$A$12;C2)) to C5, C6, C7 etc.. it is still fixed on A2, and does not move down.. i mean the average is fixed on the 1st cell displaying average of previous values, but is not copied down does not displaying averages of followed cells.

I guess should i use two index function within average formula? So the average is counted at each followed cell in column C based on C2 value?
Reply With Quote