How to calculate percentage of an autosum field in excel

0 votes

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

Nov 10 in Others by Kithuzzz
• 20,660 points
35 views

1 answer to this question.

0 votes
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.
answered Nov 11 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to create an input field in Flutter?

Hi@akhtar, There are different ways to create an ...READ MORE

answered Aug 9, 2020 in Others by MD
• 95,380 points
378 views
0 votes
1 answer

How to retrieve the value of a text field in Flutter App?

Hi@akhtar, In your TextField, you can call one ...READ MORE

answered Sep 3, 2020 in Others by MD
• 95,380 points
1,028 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
131 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
454 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
405 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,384 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,849 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
35 views
0 votes
1 answer

How to copy title of WP post dynamically to focus keyword field in Yoast SEO?

$title = get_the_title(); $args = array('posts_per_page' => -1, ...READ MORE

answered Feb 24 in Others by narikkadan
• 37,660 points
242 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP