Sum values of different columns before the last column not blank

[Julio_Moyano]

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 1	Date 1	Column 2	Date 2	Column 3	Date 3	Column 4	Date 4	Column 5	Date 5
50	12/15/2023	50	12/20/2023	100	12/25/2023	20	12/30/2023

Is there any way to do this?

[Aurelien]

Hi @Julio_Moyano 

What about: 

[column1]+[column2]+[column3]

[Julio_Moyano]

Hi @Aurelien 

I have multiple columns (5 columns are an example), and I'm exploring ways to sum the columns from first to before last as the values within these columns are populated.

[Aurelien]

@Julio_Moyano 

With no further context or example I can't help you.

[Denny774 · 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...