Summing blocks of 4 week data values

Hi Everyone

I have a set of rows which have week starting dates and underneath each date is a value

Every 4 weeks I want a sum of what those data values add up to

Is it possible to do this? I did think of using the week number as a unique identifier and a SUMIF formula but I have data that span across several years so naturally the week numbers reset

Manually this is easy enough to do however I receive new data every week so the idea would be that Excel looks at the week starting date and then calculates the next 4 weeks so that I can paste the new data in and it automatically sums up

I've attached a small example with more info as to what I'm trying to achieve

thanks for any help in advance

Dan_B

Hi ChemistB

Thanks for the reply but it's not quite what I'm looking for as in my example the first 4 weeks starting from 24/02 to 17/03 should add up to 18 and not 38 as per your example.. Perhaps my explanation was not good

I need a sum for

24/02 - 17/03 (4weeks) = 18
24/03 - 21/04 (4weeks) = 54

So first week values + the next 3 weeks values (4WKS) in total

Hope that makes more sense

Thanks

Dan_B