View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
peaspud
 
Posts: n/a
Default circular reference (Excel 2000)

Thank you all for your help.It seems to have done the trick.Problem is ,now i
have the answer, im not sure if i was doing it right in the first place.??
I shall try out the formula i have now and see if it works ok for what i
wish to do,
if it does not work i hope i can ask for all your help again???
Thanks once again

"Niek Otten" wrote:

Look he
http://www.mcgimpsey.com/excel/accumulator.html

--
Kind regards,

Niek Otten

"peaspud" wrote in message
...
Hi, I need help.I'm sure there is a simple answer,but i can't seem to find
it??!! All i'm trying to do is this:
A1 A8
25 25
Simple? I need the total (A8) to add the input number (A1), even if i
change
the input number.But all i seem to get is a "circular reference"
comment.There must be a formula out there that can help me??