How can I fix the cell reference in a function?

[Constantine]

Hello @steelenz

Information on how to change cell reference type on macOS was provided in your previous topic, please see it here:

Spreadsheet cell reference

Hello @steelenz On macOS devices to change cell reference type you should select a cell, enter = sign to start writing down formula and then use Fn+F4 combination as per Shortcuts documentation for Spreadsheet Editor.

Placing a cursor into the referenced array and using mentioned combination Fn+F4 will change reference type.

Please try to avoid creating duplicate posts. I will close your previous topic, continue communication in this one if you face any difficulties.