Formula count sum ?
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 ?
Answers

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


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

You will need to insert an AutoNumber 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)

Thanks Paul i will try and let you know !

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...

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?


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)
Help Article Resources
Categories
Check out the Formula Handbook template!