Transfer calculations

Hello all. This is a bit of an odd question but is there any way to transfer calculations made in one row in a spreadsheet to another row?

Here is the relevant document:


I have done the calculations I needed to do on the first row of the table, under the “SHOPIFY” heading.
Instead of entering all the same calculations in the other rows with the headings “BIGCOMMERCE”, “WIX”, “WEEBLY” and “SQUARESPACE”, is there any way that I could transfer the calculations made in the “SHOPIFY” row to the other rows?
The only thing that would need to change is the row number on each calculation would need to go up a number each time, as I go down to the next row.

Does my question make sense? If not I will try to add more detail.


“Does my question make sense?”
I cannot judge as I do not understand what you want to achieve. Concerning the references in your few formulae:

The adaption of row numbers you want is the standard applied to relative row addresses when copying / filling formulae.
Simply fill down the selection B3:V3. The content in H4:J7 created this way will not be what you want. Simply clear this range and enter the values you want.

(Read the Calc Guide about ‘Relative and absolute references’ in spreadsheets to understand the basic terms.)

The reworked example.

Sorry for such a basic question- as you said, all I had to do was copy/paste the info from the first row into the other rows to copy the calculation/formula.

Thanks for your time!