Using a script to generate text

[TheDarkDeity]

Hi, I am working with a script I got from someone else, and am frankly very inexperienced with this, thinking it should be simple but I couldn't find anything on how to do this with some research. The block of script im adding to is:

function DailyRewardCopy() {

  var spreadsheet = SpreadsheetApp.getActive();

  spreadsheet.getRange('Q2').activate();

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('MinerRewardLog'), true);

  spreadsheet.getRange('2:2').activate();

  spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 1);

  spreadsheet.getActiveRange().offset(0, 0, 1, spreadsheet.getActiveRange().getNumColumns()).activate();

  spreadsheet.getRange('A2').activate();

  spreadsheet.getRange('\'MinerData(DoNotEdit)\'!Q2').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('MinerData(DoNotEdit)'), true);

  spreadsheet.getRange('R2:R82').activate();

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('MinerRewardLog'), true);

  spreadsheet.getRange('B2').activate();

  spreadsheet.getRange('\'MinerData(DoNotEdit)\'!R2:R82').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, true);

  spreadsheet.getRange('CA2').activate();

  spreadsheet. (settext(=SUM(A2:BZ2)))

The highlighted part is my small addition, It is just an example to show what im trying to do, I would be grateful if someone would tell me what I need to replace that with to actually insert a sum function into a cell.

Thanks for your help

[Clark Lind]

Yes, it is pretty straight forward, but not intuitive until you become familiar with the language.  haha 

Delete the last line. 

Then change the new last line to this:    spreadsheet.getRange('CA2').setFormula("=SUM(A2:BZ2)")   //this code looks like a recorded macro, so it adds extra steps. There is no need to activate this cell, just add the formula after selecting it. :)

[TheDarkDeity]

Thanks for your help, that script works as I wanted it to