Can Someone Get Rid Of My Error? (Document Loaded)

**ninj4z** · 11-20-2007, 11:30 AM

I have a MS Excel document which I use to work out my profit and loss for items I sell. It was going all well until I moved something around and saved it. When I open it up, I ALWAYS face this error:

HTML Code:

**wmorrison49** · 11-20-2007, 11:42 AM

Cell K30 had an incorrect formula. It said SUM(K2:K35), but it should say SUM(K2:K25). You had included K30 in the sum range so Excel couldn't put the total result in a cell it was supposed to be adding up in the total. So long story short, change K30 to

=SUM(K2:K25)

**ninj4z** · 11-20-2007, 11:46 AM

damn, your a genius, how did you spot the error so quick??

and as you can see its like a profit/loss account, if anyone knows about profit/loss accounts, can they tell me if all my calculations and formulas are correct to reach a final conclusion of:

1) What I'm Making
2) & If Im In Profit/Loss

**wmorrison49** · 11-20-2007, 11:59 AM

I don't know what version of Excel you have, but I am using Excel 2007. I went to Formula Auditing -> Circular References, and then it showed me which cell had the circular reference. Then I just went there and fixed it.
As for the profit/loss, you know your data better than anyone. Things look ok to me and your evaluation is correct that you made a profit just over 100L, but you would be in the best position to figure that out.