imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
I am trying to keep track of annual and career earnings for a small group (about 50) of golfers. I would like to use one column to enter the earnings this week and add that amount to the annual and career earnings. I am not a sophisticated excel user. I created four columns:
A B C D
NAME THIS WEEK ANNUAL CAREER
John Doe 10.00 100.00 200.00
The formula in C is =SUM(B2,C2) and D is =SUM(B2,D2). I get a circular reference error message. Is there some way to accomplish this?
A B C D
NAME THIS WEEK ANNUAL CAREER
John Doe 10.00 100.00 200.00
The formula in C is =SUM(B2,C2) and D is =SUM(B2,D2). I get a circular reference error message. Is there some way to accomplish this?