Circular Reference
 

G'day All,
I have a workbook for a sporting competition containing 1 sheet for each
event to calculate player performance and a sheet showing the championship
table.

After each round I add the results for that event. Then I want to apply a
"leveling" formula based on the total score 'to date' in the championship
table. This creates a circular reference and also changes the leveling
adjustment for previous weeks.

Can anyone suggest a method of achieving the desired effect without entering
the levelling scores by hand?

Thanking you in anticipation,
build

Circular Reference
 

Most likely you have a formula like:

=A2/SUM($B$2:$B$20)

and this formula is in cell B2, hence it is referring to itself.
Compute the sum in another cell (e.g. C2) and then use A2/C2.

Does this help?
Kostis Vezerides

On Oct 19, 3:47 am, "build" wrote:
G'day All,
I have a workbook for a sporting competition containing 1 sheet for each
event to calculate player performance and a sheet showing the championship
table.

After each round I add the results for that event. Then I want to apply a
"leveling" formula based on the total score 'to date' in the championship
table. This creates a circular reference and also changes the leveling
adjustment for previous weeks.

Can anyone suggest a method of achieving the desired effect without entering
the levelling scores by hand?

Thanking you in anticipation,
build