How to pin a formula to a column in Google Sheets?

Question

Google Sheets

Greetings! Can you please tell me whether it is possible to assign a formula to a column, so that even when adding rows at the end, it is automatically pulled down?

Answer 1

You can use an array formula , it will work for the entire column / row
As an example, let's place numbers in columns A and B , and set the formula in column C1 :
=ArrayFormula(A:A+B:B)
this way there is no need to fill in the formula in all rows, when adding data to A and B , they will be summed up and displayed in column C