How to calculate percentage of an autosum field in excel

Question

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:

=[@[Columnname]]/Table1[[#Totals];[Columnname]]

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).

Answer 1

The fact that I was using the "track tasks" template—I'm not sure its name in English—caused the problem. Essentially, it is a table with a percentages-filled column. The user chooses those percentages in the template from a drop-down menu. Instead, my modification should compute those percentages. Due to the fact that the calculated values are not always among the numbers in the drop-down list, in this instance 5. This is what Excel means by "not a listed value" (0, 25, 50, 75, and 100).

I hope this helps you.