Formula count sum ?

MvdM

Hi everyone i am looking for a formula. Example: if there is a number in a cell, I want to add the number of the other cell. Example: Cell 1 is the number 2. in cell 2 is the number 3 then the answer should be 5 if i then enter in cel 1 the number 2, the answer should be 7. if I then enter in cell 1 -2 the answer should be 5. is this possible ?

Paul Newcome

Are you able to provide a screenshot with manually entered mock data that shows what you are wanting to accomplish?

MvdM

MvdM

@Paul Newcome nice that you want to think along with me!

Paul Newcome

You will need to insert an Auto-Number column (called "Auto" in this example and formatting doesn't matter). You would then insert a text/number column (called "Row" in this example) and enter this column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then in Column 2 you would use this:

=SUMIFS([Column1]:[Column1], Row:Row, @cell<= Row@row)

MvdM

Thanks Paul i will try and let you know !

MvdM

hi Paul it works! but I forgot to explain something in my example the lines were one below the other. but i am looking for a solution in 1 horizontal row. my example was to show what i would like to see what happens but in 1 row. do you have a solution for that too? I know there's a chance I'll have to add extra columns then...

Paul Newcome

I'm not sure I follow. Are you able to provide a screenshot with some mock data filled in that shows what you are actually trying to accomplish?

MvdM

Paul Newcome

So basically you are wanting to update the cell [Column1]2 multiple times and each time that cell is updated the cell in [Column2]2 will keep the running total?

If that is the case then you would need a column that contains a unique ID on every row that you want to do this on. You would then set up a Copy Row automation that copies the row to another sheet every time the cell in [Column1] is updated.

From there you would use a SUMIFS with cross sheet references to total up everything.

=SUMIFS({Other Sheet Column 1}, {Other Sheet Unique ID}, @cell = [Unique ID]@row)