Google sheet query

[mbmc]

In Google sheets I want that if I enter data to b1 it gets added to a1 and after adding b1 turns blank again to enter more data. For example if a1 is 100 and if I enter 10 in b1 then a1 becomes 110 and b1 becomes blank for more data how can I do that please help ?

 

[pjmorris]

IN Sheets, Click on Extensions, click on Apps Script. The next screen will show a blank function, delete it and replace with the code below. Click 'Save' (looks like a floppy disc) if successful Run, Debug etc will nolonger be greyed out.

function onEdit(e) {
  const rangeEdited=e.range;
  var editSheet=e.range.getSheet().getName();
  var editColumn=rangeEdited.getColumn();
  var editRow=rangeEdited.getRow();
  if (editRow==2 && editColumn==1){
    rangeEdited.offset(-1, 0).setValue(rangeEdited.offset(-1,0).getValue()+rangeEdited.getValue());
    rangeEdited.setValue("");
  }
}