PPRuNe Forums - View Single Post - Excel help
Thread: Excel help
View Single Post
Old 1st Jun 2018, 21:53
  #2 (permalink)  
DIBO
 
Join Date: Dec 2007
Location: same planet as yours
Posts: 551
Received 7 Likes on 6 Posts
not perfect, but you could start with this:

col. A col. B
date1 amount1
date2 amount2
date3 amount3 =SUMIF(A:A,">"& (NOW()-365),B:B)
DIBO is offline  
Reply