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!
--
dxm
------------------------------------------------------------------------
dxm's Profile:
http://www.excelforum.com/member.php...o&userid=23761
View this thread:
http://www.excelforum.com/showthread...hreadid=374153