Hi,

I wonder if someone could help me with this:

My spreadsheet keeps simple statistics of how many calls are received in a given week ("B2"), the total for the month ("C2"), and an overall total (which includes all calls since we started keeping track; displayed in "E2").

B2 C2 E2
Current May Overall
Week Total Total

5 25 2500

What I would like to happen is that the monthly and overall totals are updated when I manually change the weekly number (i.e., a change in B2 makes appropriate changes in C2 and E2). I can't seem to get around the circular reference problem of adding something to an existing value and displaying it in that same cell.

Any ideas?

Thanks!