PPRuNe Forums - View Single Post - Excel - Applying formulae down a column and calculating a rolling sum
Old 16th Mar 2011, 08:45
  #5 (permalink)  
captainspeaking2U
 
Join Date: Feb 2008
Location: Planet Zog
Posts: 5
Likes: 0
Received 0 Likes on 0 Posts
Hello

In cell C1 add =sum(a1*2)-b1 when you have a value in C1 put your cursor in that cell and press copy, then hi-light the cells you need ie C2 onward, then press paste. This will insert the correct formulea into all the cells hi-lighted. Hope this is OK

Geoff
captainspeaking2U is offline