sum 3 days before and 3 days after

[uqls]

Hi
Please can you help me.
My spreadsheet is like this (please see the attached):

I want to use a sum formular according to my pre-defined criteria (detail in excel).

Sum criteria include 3 days before, and 3 day after.

Is there any excel formular that allow me to do automatically?



Many thanks

[TMS]

Try:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Phuocam]

Or try this in G4:

=SUM(OFFSET(B2:B458,MATCH(MAX(C2:C458),C2:C458,0)-4,0,3,1))

in G6:

=SUM(OFFSET(B2:B458,MATCH(MAX(C2:C458),C2:C458,0),0,3,1))

[uqls]

Thanks you so much

[TMS]

You're welcome. Thanks for the rep.