Please Help:Circular Reference Problem

  • Thread starter Thread starter Babbagene
  • Start date Start date
B

Babbagene

Hi , I am new to this forum and right now extremely frustrated. I am
using Microsoft works Spreadsheet. I want to calculate total wins by
various handicappers each night.So before the season starts there are
"0" total wins,each night players will make selections and add wins to
their total.
I have "cell" B2 to represent the total wins thus far.
I have "cell" F2 to represent the wins for the Night.
My goal is to have B2 keep a running total of all the wins for each
night for a specific handicapper.
Thus if handicapper #1 won 3 games the first night his TOTAL wins in B2
should read 3,the next night if handicapper #1 wins 2 games ,the TOTAL
in B2 should now read 5,if the next night the handicapper wins 4 games
then the TOTAL in B2 should now read 9.
So I thought I could just use this formula in "cell B2" =B2+F2, however
when I do this I get a Circular reference message and the figures do
not add correctly.
Can anyone please tell me what I need to do to get this to work the way
I have described?
Please Help.
Thank You
 
Hi,

A circular reference happens when you try to calaculate the value of a
cell by making reference to that cell. You can't do it.

I think all you you have to do is add a third total as shown below. At
the end of the day, the total in F3 moves to B2 and F2 is ready to
start again on a new day.

B2 Past wins
F2 Wins on the night
F3 Total wins (=B2+F2)

Cheers,

Graham
 
Thanks for your help.I do not understand how the total in f3 then moves
to b2 ,I can't figure out how that happens . Sorry I am so ignorant on
this issue ,but can you please spell it out as easy as possible,I
don't understand how F3 goes into the b2 cell.
Thank You
 
Is there a way to have the value of cell F# automaically be put into
cell B2 at the end of the night ,if so thats great!
 
Hi,

If it's only one cell, the easiest way is to do it manually - just type
the contents of F3 into F2, or use Edit - Copy in F3 then Edit-Paste
Special - Values in F3

There are a number of relatively simple ways of automating this if you
need to - try using the macro recorder and attaching the macro to a
button - look up the macro recorder in the help file.

If your problem is more complicated than this, you'll need to provide a
bit more detail.

Cheers,

Graham
 
Back
Top