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