SOLVED

# Sequential subtraction using criteria and a starting amount

Copper Contributor

# 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

best response confirmed by J-Des000 (Copper Contributor)
Solution

# Re: Sequential subtraction using criteria and a starting amount

That could be

``=LET( v, (amount-values)*(dates=thisDate), IF(v=0, "", v) )``

1 best response

Accepted Solutions
best response confirmed by J-Des000 (Copper Contributor)
Solution

# Re: Sequential subtraction using criteria and a starting amount

That could be

``=LET( v, (amount-values)*(dates=thisDate), IF(v=0, "", v) )``