“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

So for some reason my excel referencing isn't generating a correctly calculating formula.
I've got one tab for adding up various values in a development (i.e. construction costs, professional fees etc.) In one column on this tab is the actual numerical value let's say $100,000. And in the adjacent column is a designation on who is paying for it. So the right hand column might read "Investor 1"
On a 'Summary Tab' I specifically reference the 'Values Tab' with the following formula:
=SUMIF(Values_Tab!$N$9:$N$116,$G41,Values_Tab!$Y$9:$Y$116)
Where G41 is the Name 'Investor 1'
The formula appears to be correctly adding up the Values on the Values Tab and I get the following values
Investor 1 = 432,000
Investor 2 = 948,000
Investor 3 = 210,000
Now here is where it goes wrong. When I run a simple Sum formula of those three values it returns 1,154,000 NOT 1,590,000 which is the correct amount.
Additionally, when I use those values to calculate percentage Ownership they don't function correctly. Investor 1 get a 1.4% Ownership, not a 27.2% Ownership. Investor 2 gets a 82.2% Ownership, Not the correct amount of 59.6%. And Investor 3 gets a 16.5% Ownership, instead of a 13.2%.
What seems so odd is that the numbers are appear to properly reference the original list, and correctly subtotal their values. But then when that subtotaled value is used in any form of a calculation after that, they don't correctly compute.
What am I doing wrong?

Solved by T. S. in 19 mins

I have seventeen criteria of percentages that amount up to 100%. Out of the 17, 5 are 15.1% (=IF(C4="Yes",(100-((100-15.1*5)/12)*12)/5,0) each because they are heavy weighted. The remaining 12 cells represent the remaining value evenly distributed amongst them which amounts up to 2.041667 (=IF(C3="Yes",(100-15.1*5)/12,0).
Adjacent to these cells we have a drop down option that have three options to choose from (Yes, No and N/A).
The way it is programmed right now is that if Yes is chosen, the percentage will be calculated into the total as a sum. If no is chosen then to the adjacent cell instead of the percentage 0 will be recorded.
What is required to be done however is N/A. The reason that provides me with problems is that due to it stating zero the total percentage drops down. For that what is required is that the value of the cell adjacent to N/A, it is evenly distributed amongst all other cells adjacent to yes or no. Meaning if there is one or two N/A and the remaining cells are still showing yes. The total percentage would still be 100.
Any help would be much appreciated, thank you.
There is one column where there is an opposite case going on, meaning if there is yes selected then the percentage will not be added and if there is a no, the percentage will be added.
Thank you in advance,
Afaq

Solved by A. A. in 29 mins

I need to get an excel range count for the duplicate names. Then I need to find out what percentage of all the names have duplicates. I have already counted the data. I just don't know how to count the duplicates. Thanks!

Solved by A. H. in 16 mins

I am trying to get the graph under 'Monthly Graph' to show the percentage as an average for each line inserted

Solved by X. U. in 25 mins

Create a formula with structured references to calculate the percentage of the list price.
Note: You are creating a ratio, a comparison of one number to another number (set up like a fraction). You are comparing the selling price to the list price.

Solved by S. A. in 18 mins

I was just working with someone on your team who created this chart, i would like help with turning the chart into a line graph that plots the percentages (x-axis) of the chosen Picker ID's (it should add or removes lines according to the filtered information by plotting the percentage for each day of the week (y-axis).

Solved by V. U. in 19 mins

i need to calculate values of cell based off of a benchmark number minus a percentage according to how far in the future something is compared to today

Solved by D. L. in 17 mins

What is the popularity of Pryor Seminar Courses? (Of the total number of students who have taken classes, give the percentages of the popularity of each course (in terms of the number of enrolled students) in comparison to all courses combined. Create a pie chart showing the percentage of offerings for each course as compared to the total courses offered. Create a PivotTable report (Course No. as the Row Labels and Class Size as summed Values) AND a PivotChart report (Exploded Pie Chart) in the worksheet titled Q2CrsPopularity. Make sure to include BOTH, the PivotTable and PivotChart, on the same worksheet. Add a descriptive title to the PivotChart and format it with appropriate labels for a user-friendly presentation style. Be creative in formatting the chart.

Solved by K. L. in 29 mins

What is the popularity of Pryor Seminar Courses? (Of the total number of students who have taken classes, give the percentages of the popularity of each course (in terms of the number of enrolled students) in comparison to all courses combined. Create a pie chart showing the percentage of offerings for each course as compared to the total courses offered. Create a PivotTable report (Course No. as the Row Labels and Class Size as summed Values) AND a PivotChart report (Exploded Pie Chart) in the worksheet titled Q2CrsPopularity.

Solved by A. H. in 28 mins

In cell J5, insert a function (PMT) to calculate the first client’s monthly payment.
Remember to convert the annual percentage rate into an appropriate periodic rate.
Think about how the nper (number of payments over the life of the loan) is calculated.
Change the sign of the result, inserting a minus sign before the function's name, in order to have the result display as a positive number instead of a negative number.
As this function will be copied to other cells, determine whether each cell reference should be absolute value of negative number.

Solved by X. B. in 15 mins