Adding info from the row bellow in a table

1

Hi!

Can anyone help me figuring out how I can use a formula so that I can get the result from the last row to the next one and so it adds o subtracts automatically?

I need the formula to be only working with the grouped names on the left?

Green - sum (red + red + red) = in purple but only for this group with the name on the left and so on for every person

Screen Shot 2022-03-02 at 5.24.10 PM
Screen Shot 2022-03-02 at 5.24.10 PM1115×538 56.2 KB

Thanks a lot,
:grinning:

2

Sorry the column “Total Vuelo” is algo red

3

hi @JEC_Aviation ,

Could you have a look here to see if this principle applies to what you have in mind:

In case it does not, what is the missing link or issue this approach won’t solve?

Cheers, Christiaan

4

Thanks so much for writing.

I sort of understand but I think that formula is more advance than I am (only been here a month) :blush:

I will try it, but thanks again.

5

hi @JEC_Aviation , I can imagine you feel overwhelmed by the formulas put at work. I remember very well in the beginning that I did not understand how something could work, but felt relieved that it did work :wink: . What might help is sharing a demo doc that contains a table that looks like the official one with a column that contains hard coded the outcome you look for. This helps us to support you in finding a solution. Cheers, Christiaan

1 Like
6

Hi Christiaan!

How can I share just a demo so that people only have access to that page?

thanks again!

7

if you have a team plan, you lock all the other pages
if you are on pro, you copy this page to a new doc and share this new doc with us
courage! :wink:

1 Like
8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.