Is there a cumulative sum function solution to variably ordered array used in an if statement? E.g. if($a$1<$a$7,sum($a$1:an->a7),sum($a$7:an->a1))
i.e. point of summation is different when the order is ascending versus descending.
If I use this syntax the relative coordinates in the descending order alternative get jumbled when I drag the formulae entered in the range from b1:b7. Alternatively, the ascending order function gets jumbled if I drag/copy from b7:b1
Do I really have to hard code the inverse cumulative sum range because it does not follow the direction of the dragged/copied formula? 🤮