Formula to sum variable number of values in a column variable by date lookup ...

Many thanks in advance for any guidance provided.

Problem Description

My column A has randomly spaced yet increasing reporting dates going back over time. So sometimes consecutive dates would be present other times gaps of multiple days would also be present.

My column B has points entered for each date row.

I want my column C to show the sum of all points going back over the last 7 days from the date of the row. So sometimes that could be 2 rows back other times 3 or 4 etc ... it varies.

So I need a formula in my active cell in column C that takes the date of my row from column A looks back up column A till it sees a date 7 days earlier then sums up the points from that row in column B to my current row in column B placing the sum total in my active cell in column C

Kind regards

SNP529

Hi Ali .... brilliant !! That fixed it just as required. You are a star.
Kind regards
Simon