SOLVED

Sequential subtraction using criteria and a starting amount

Copper Contributor

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

today2024-01-27    
amount500    
      
Dates2024-01-272024-01-272024-02-272024-03-252024-04-14
values1000.00800.00 750.00 
      
output as spilled range-500-800   

 

My thanks in advance.

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

@J-Des000 

That could be

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

image.png

1 best response

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

@J-Des000 

That could be

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

image.png

View solution in original post