formula problem

[Guest]

B C E
Comp time hours Total Compt time Compt time used Compt time balanc

3 12 12 16 -
4 12 24 0
5 12 36 0
6 12 48 0
7 12 60 0
8 12 72 0
9 12 84 0
10 84 3
11 0.34 0
12 84.34 0
13 0.34
In the above spread sheet I am having a problem getting the formula to work in the Compt Time used column. What I have used is the following
Compt Time used: =if(E3="","",SUM($E$2:E3) How can I by pass the circular reference error? Also when I fill the formula down it does not fill in correctly nor does it recognize new imput such as the 3 on line E10. I want it to show total Compt time used all the way down the column

Thank you for your assistanc

 

[Arvi Laanemets]

Hi

Which cell are you trying to put this formula into? Or even better - What do
you want to do?


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

B C E G
Comp time hours Total Compt time Compt time used Compt time balance
1
3 12 12 16 -4
4 12 24 0
5 12 36 0
6 12 48 0
7 12 60 0
8 12 72 0
9 12 84 0
10 84 3
11 0.34 0
12 84.34 0
13 0.34 0
In the above spread sheet I am having a problem getting the formula to

work in the Compt Time used column. What I have used is the following:

Compt Time used: =if(E3="","",SUM($E$2:E3) How can I by pass the circular

reference error? Also when I fill the formula down it does not fill in
correctly nor does it recognize new imput such as the 3 on line E10. I want
it to show total Compt time used all the way down the column.

 

[Bob Phillips]

Clare,

You can't have a formula that uses itself as part of the input, because this
means you are trying to use a cell for 2 purposes, to hold a value, and to
hold a formula, just can't be done. You need to put your sum formulae in
separate cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

B C E G
Comp time hours Total Compt time Compt time used Compt time balance
1
3 12 12 16 -4
4 12 24 0
5 12 36 0
6 12 48 0
7 12 60 0
8 12 72 0
9 12 84 0
10 84 3
11 0.34 0
12 84.34 0
13 0.34 0
In the above spread sheet I am having a problem getting the formula to

work in the Compt Time used column. What I have used is the following:

Compt Time used: =if(E3="","",SUM($E$2:E3) How can I by pass the circular

reference error? Also when I fill the formula down it does not fill in
correctly nor does it recognize new imput such as the 3 on line E10. I want
it to show total Compt time used all the way down the column.