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, 2022 in Others by Kithuzzz
• 28,520 points
62 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, 2022 by narikkadan
• 52,760 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,420 points
476 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,420 points
1,111 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, 2022 in Others by narikkadan
• 52,760 points
233 views
0 votes
1 answer
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,740 points
529 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
477 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,498 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
3,006 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, 2022 in Others by narikkadan
• 52,760 points
79 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, 2022 in Others by narikkadan
• 52,760 points
357 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