You can address these cells directly. In a calculation you can refer to a specific cell in the spreadsheet and use its content.
Procedure
Prerequisite
A table view is created for the query or the ad-hoc analysis.
Procedure
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.