What am I doing wrong that G3165 won't sum the Regions that have AK? The sum should be 731,449. Little help?Sum Help.xlsx
What am I doing wrong that G3165 won't sum the Regions that have AK? The sum should be 731,449. Little help?Sum Help.xlsx
It's a circular reference..
=SUMIFS(G:G,F:F,A3165)
But you put the formula in G3165 (which is within G:G)
A formula can't refer to itself..
Hi,
The circular reference is your issue.
Regards
Since you are summing the entire column of G, it would seem to be a circular reference problem.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
You did what?
Note, you will still get 0 if you just put the formula in a different column.
You must also 'resolve' all the circular references.
The existance of a circular reference can halt future calculations.
so if you still have the same formula in G3165, but just add the formula somewhere else, you still have a circular reference in the original cell.
The new formula will still return 0 until you 'resolve' the circular reference in G3165
Last edited by Jonmo1; 08-19-2013 at 05:26 PM.
See the attached. I used the formula you suggested, but it still comes back as 0. I can't figure it out!
Sum Help.xlsx
I apologize - I took your =SUMIFS(G:G,F:F,A3165) to be a solution.
Any ideas on what I can do to get this to sum correctly?
g3165 =SUMIF($F$2:$F$3164,$F3165;$G$2:$G$3164)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You need to move that blue area to a new sheet. It seems like some kind of summary. Above it you have directly entered values, but the summary formulas include the whole columns, thus including the formulas themselves in the formulas: circ ref errs. You could also leave it as is but change the formulas from G:G, F:F to G2:G3100, etc.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks