First, the circular reference message indicates that the formula you entered contains the cell the formula is in. For example, in cell A3 a formula "=sum(A1:A5)" would generate a circular reference message. Second, to subtract a quantity from the total of a set of cells, suppose the amount you want to subtract is in cell B10 and the range of cells you want to total is in range C1 to C20, the formula you should enter is =sum(C1:C20)-B10. If you want to remove a known amount such as 500 the formula would be =sum(C1:C20)-500.
Loren Schoof [email protected] --- On Thu, 8/26/10, Larry Stansifer <[email protected]> wrote: > From: Larry Stansifer <[email protected]> > Subject: Re: [JAWS-Users] Subtraction in Excel > To: [email protected] > Date: Thursday, August 26, 2010, 9:25 AM > Hi Ann, > > I get the message that tells me that I have created a > circular reference and Excel can not calculate the > formula. > Any ideas? > > TNX > > Larry > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] > On Behalf Of > Ann Byrne > Sent: Thursday, August 26, 2010 9:18 AM > To: [email protected] > Subject: Re: [JAWS-Users] Subtraction in Excel > > > =sum(total-a3) > > > At 09:45 AM 8/26/2010, you wrote: > >Hi folks, > > > >I am using Jaws 10.latest, windows XP-Pro and > Office-XP. > >I have forgotten how to subtract a column of numbers > from a > total. > >Any assistance you can provide without laughing would > be > >greatly appreciated. > > > >TNX > > > >Larry > >For answers to frequently asked questions about this > list > visit: > >http://www.jaws-users.com/help/ > > > For answers to frequently asked questions about this list > visit: http://www.jaws-users.com/help/ > > > -- > BEGIN-ANTISPAM-VOTING-LINKS > ------------------------------------------------------ > > NOTE: This message was trained as non-spam. If this > is > wrong, please correct the training as soon as possible. > > Teach InfoWest Spam Trap if this mail (ID 01CX3jhWC) is > spam: > Spam: > https://spamtrap.infowest.com/canit/b.php?i=01CX3jhWC&m=4a5c > 7eda3937&c=s > Not spam: > https://spamtrap.infowest.com/canit/b.php?i=01CX3jhWC&m=4a5c > 7eda3937&c=n > Forget vote: > https://spamtrap.infowest.com/canit/b.php?i=01CX3jhWC&m=4a5c > 7eda3937&c=f > > REMEMBER: Never give out your account information, > password, > or other personal information over e-mail. > ------------------------------------------------------ > END-ANTISPAM-VOTING-LINKS > > > __________ Information from ESET Smart Security, version > of > virus signature database 5399 (20100826) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > For answers to frequently asked questions about this list > visit: > http://www.jaws-users.com/help/ > For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
