I have a table with a column of numbers and a cell in the last row that contains the sum of those values that I added using the AutoSum feature. I want to figure out what portion of the total value the number in one row represents. I'm doing this clumsily by clicking on a cell for the % and typing =, then I click on the cell with the actual amount, then I click on the cell with the total value, and finally, I type /. The formula that Excel inserts are:
However, Excel informs me that this is not a listed value when I press Enter.
How do I correctly address the cell in this column's last row? Note that the same message is received even when you call the cell using its current cell number (for example, C8).