Dynamically Relocate a Formula Associated with a Dynamic Range
You can do this with a formula:
=LET(filt,FILTER(O1:O51,O1:O51>E1),CHOOSE(INT(SEQUENCE(COUNT(filt)+1,,0)/COUNT(filt))+1,filt,SUM(filt)))
INT(SEQUENCE(COUNT(filt)+1,,0)/COUNT(filt))+1 returns an array of 1s the count of the numbers returned by the FILTER and append a 2 to the end. Then with CHOOSE we return first each number in the FILTER then the 2 returns the SUM.
