Sep 14 2020 06:25 AM
Post with question was published some ago and deleted in a short while. The task is to find minimum sum of any sequential 7 records.
formula could be
=MIN(
MMULT(
INDEX($B$3:INDEX($B$3:$B$100,COUNTA($B$3:$B$100)),
SEQUENCE(1,DaysNumber)+SEQUENCE(COUNTA($B$3:$B$100)-DaysNumber+1,1)-1
),
SEQUENCE(DaysNumber,1,1,0)
)
)