Forum Discussion
Sequential subtraction using criteria and a starting amount
Hi,
I'm having trouble creating a formula for this. I need it to sequentially subtract if equal to the selected date and if not then leave blank regardless if any value is entered. Need this to output as a horizontal spilled range and not use volatile functions (as my workbook is already fairly big)
Ex: Sum only if equal to value in today cell using the starting value in amount cell
| today | 2024-01-27 | ||||
| amount | 500 | ||||
| Dates | 2024-01-27 | 2024-01-27 | 2024-02-27 | 2024-03-25 | 2024-04-14 |
| values | 1000.00 | 800.00 | 750.00 | ||
| output as spilled range | -500 | -800 |
My thanks in advance.
