Ens SUM i begge kolonner.

Hjælp skriver dette. Måske kan dette hjælpe.

Allow or correct a circular reference
When a formula refers back to its own cell, either directly or indirectly, it is called a circular reference. Microsoft Excel cannot automatically calculate all open workbooks when one of them contains a circular reference. You can remove a circular reference, or you can have Excel calculate each cell involved in the circular reference once by using the results of the previous iteration. Unless you change the default settings for iteration, Excel stops calculating after 100 iterations or after all values in the circular reference change by less than 0.001 between iterations, whichever comes first.

Locate and remove a circular reference

If the Circular Reference toolbar is not displayed, click Customize on the Tools menu, click the Toolbars tab, and then select the Circular Reference check box.
On the Circular Reference toolbar, click the first cell in the Navigate Circular Reference box.
Review the formula in the cell. If you cannot determine whether the cell is the cause of the circular reference, click the next cell in the Navigate Circular Reference box.
Note  The status bar displays the word "Circular," followed by a reference to one of the cells contained in the circular reference. If the word "Circular" appears without a cell reference, the active worksheet does not contain the circular reference.

Continue to review and correct the circular reference until the status bar no longer displays the word "Circular."
Tips

When the Circular Reference toolbar appears, tracer arrows appear that point out the cells that depend on the formula.

You can move between cells in a circular reference by double-clicking the tracer arrows.

Make a circular reference work by changing the number of times Microsoft Excel iterates formulas

On the Tools menu, click Options, and then click the Calculation tab.
Select the Iteration check box.
To set the maximum number of times Microsoft Excel will recalculate, type the number of iterations in the Maximum iterations box. The higher the number of iterations, the more time Excel needs to calculate a worksheet.
To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum change box. The smaller the number, the more accurate the result and the more time Excel needs to calculate a worksheet.

Håber at dette kan hjælpe. Se nedre del af teksten...

Lars

I B10 skriver du

=HVIS(SUM(B1:B9;B11)<C12;C12-SUM(B1:B9;B11);0)

svar:-)

Som du havde formuleret opgave skulle forskellen kun skrives hvis C>B, ensbetydende med at der er OK at B>C.

Hvis altid vil have B=C, ensbetydende med at B10 kan være negativ er fomlen

=C12-SUM(B1:B9;B11)

Hvis der er meningen at du vil have B12=C12 i alle tilfælde, og sætte diff. i B10/C10 alt efter hvilken kolone er mindst kan du bruge følgende formler

B12:=MAKS(SUM(B1:B9;B11);C1:C9;C11) - har du en engelsk excel - MAKS=MAX
C12:=B12

B10:=B12-SUM(B1:B9;B11)
C10:=C12-SUM(C1:C9;C11)

katborg
Mange tak for løsningen, den funger perfekt

:D velbekomme