Solved: Sum values of different columns before the last co... - Page 2

Julio_Moyano · 01-04-2024 06:43 AM

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?

Denny774

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

Sum values of different columns before the last column not blank