PPRuNe Forums - View Single Post

1st June 2018 | 21:53

#2 (permalink)

DIBO

Joined: Dec 2007

Posts: 952

Likes: 449

From: same planet as yours

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)

Reply