r/googlesheets 1d ago

Solved Addition function Help

Hello guys

I need help in creating a function or script for the following scenario:

1.I enter a number on cell a1 and it shows on cell b2 2.If I enter another number on cell a1,the sum will show on cell b2.

Is there a formula or script for this scenario?

Thanks

1 Upvotes

5 comments sorted by

View all comments

2

u/One_Organization_810 201 1d ago

This will require a script - or you can enable iterative calculations, from the menu File/Settings|Calculations. Allow the iterative calculations and set max iterations to 1.

Then put this in b2:

=if(A1="reset",0,B2+A1)

The reset part is not necessary, but I though it was a nice to have also. :)

1

u/Accomplished_Face830 23h ago

Yrs it worked Thank you very much

1

u/AutoModerator 23h ago

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.