Circular reference help please!

S

steve

Hi
I have a problem with circular reference in excel. I need a total
displayed in one cell address and i need it reduced accordingly by
entries into another cell address. eg- A3 contains 1000. A20 is used
for input and when operator puts in say 100 then A3 is reduced to 900.
We need up to 30 consecutive inputs. Any help would be appreciated -
Thanks
 
F

flummi

Are all cells A20:A49 to be subtracted from A3?

Where does the 1000 in A3 come from? Is that an input?

Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular reference help 3
Circular reference toolbar not working 3
Assistance with circular reference 3
Circular reference, Indirect, and Sum 3
Circular reference "help" 3
Inserting current date when number entered in cell & Circular reference error? 4
adding on to an existing total & avoiding a circular reference blo 1
Help on Circular Reference, 1

Top