Hi again,

Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. Tried using TAKE function

Ex

2024-11-18      2024-05-12    2024-10-09     2024-11-18   2024-10-09

50                     100                 30                     75                90

Output all summed previous numbers as a horizontal spilled range that are equal to 2024-11-18

Output:

2024-11-18       2024-05-12      2024-10-09      2024-11-18     2024-10-09

50                         n/a                    n/a                  125                 n/a

If it could also display n/a or 0 as a value that would be great (e.g changeable between both). Thanks

​Hi again, Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. Tried using TAKE function Ex2024-11-18      2024-05-12    2024-10-09     2024-11-18   2024-10-0950                     100                 30                     75                90 Output all summed previous numbers as a horizontal spilled range that are equal to 2024-11-18Output:2024-11-18       2024-05-12      2024-10-09      2024-11-18     2024-10-0950                         n/a                    n/a                  125                 n/a If it could also display n/a or 0 as a value that would be great (e.g changeable between both). Thanks    Read More

​