Forum Discussion
Excel
hello. such a question. how can I make the sum of certain cells in the next row be filled in automatically? For example, the formula for one cell is as follows: =SUMS('Form Responses 1'!P2;'Form Resp...
In this case, are there any rules for copying and pasting a formula into the next line? Or for what reasons the cell numbers of the next row may not be automatically substituted in the next row?
In this case, are there any rules for copying and pasting a formula into the next line? -- Depends on your sheet and your expected results. Excel and Google Sheets will automatically increment the row number when you drag or copy the formula down to the next row.