I have a document that is divided in seven sections, each one containing different amounts of lines. It was created to keep count of how many cells are filled out (work completed) in each section, and then to calculate the percentage for each section and finally the percentage for the whole worksheet.
The sections have as calculation the following example:
The last cell in the column uses the following:
which treats each section as having the same number of cells, which is not the case.
Is there a way, in the last cell, to calculate the percentage for all cells in the worksheet using the subcalculations by section?