Sum values of different columns before the last column not blank

Hi, 

I have tried to create a virtual column to SUM de values of each columns before the last column not blank. I tried to use the date because it is always more current

In this case the sum should be 200 

 

Column 1Date 1Column 2Date 2Column 3Date 3Column 4Date 4Column 5Date 5
5012/15/20235012/20/202310012/25/20232012/30/2023  

Is there any way to do this?

Solved Solved
0 4 344
1 ACCEPTED SOLUTION

Hey man,

you could do something like that:
Virtual Column App Formula = 
IFS(ISBLANK([Column2]), [Column1], ISBLANK([Column3]), [Column1]+[Column2], [Column3], TRUE, 0)   

and so on, depending on how many columns you actually got in your table...

View solution in original post

4 REPLIES 4
Top Labels in this Space