You can address these cells directly. In a calculation you can refer to a specific cell in the spreadsheet and use its content.
Procedure
Open a spreadsheet.
Enter the relevant formula, for example, SUM. Enter a dollar sign ($) in front of both the column and the row:
Copy these cells and paste them at another position in the spreadsheet.
The references in the formula have not changed:
You can also enter the dollar sign only in front of the column or only in front of the row in order to save only the column or the row.
You have inserted fixed cell references. If you insert the calculation cell at another position, the calculation of the original area is retained.