I am currently calculating percentages in LibreOffice Calc using the function
TOTAL are cell coordinates of a same column.
Dragging-down the formula won't do, because the coordinate of the
TOTAL cell will change along with the PART's.
Ideally, I want to process this quickly, in a way that the coordinates of the
PART changes while the
TOTAL's would remain the same.
How can I do that? Is there a function for this?