Minimum sum for sequential 7 days

MVP

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.

image.png

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)
   )
)

 

0 Replies