PPRuNe Forums - View Single Post - Excel - Applying formulae down a column and calculating a rolling sum
Thread: Excel - Applying formulae down a column and calculating a rolling sum
View Single Post
Old 16th Mar 2011, 08:51
  #6 (permalink)  
mike-wsm
Guest
 
Posts: n/a
To get your sum of the past 100 results I'd suggest using a column that is the running total of all results and then a further column that is value n minus value (n-100).
 
Reply