sorry for asking this but...

simonj · 01-31-2012, 01:50 PM

This is probably the wrong place to ask but I have an excel problem that is driving me crazy.

I need a formula to add another cell's contents to this cell. in programming it would be something like a=a+b but in excel it creates a circular error. Are there variables in excel, or another simple way of doing this?

***Corey*** · 01-31-2012, 01:53 PM

use brackets eg

a=(a+b)

simonj · 01-31-2012, 02:01 PM

I'm not sure that works..let me clarify

in cell B1 I want to put =B1+A1, so that B1 keeps a running total (sum) of all the numbers that were in A1 (ie. whenever A1 changes, it's added to B1)

defaultuser · 01-31-2012, 02:03 PM

Originally Posted by simonj

This is probably the wrong place to ask but I have an excel problem that is driving me crazy.
????: NamePros.com http://www.namepros.com/programming/745213-sorry-for-asking-this-but.html

I need a formula to add another cell's contents to this cell. in programming it would be something like a=a+b but in excel it creates a circular error. Are there variables in excel, or another simple way of doing this?

Use a third cell? c=a+b

simonj · 01-31-2012, 02:11 PM

Originally Posted by defaultuser

Use a third cell? c=a+b

i thought of that but that then creates the problem of keeping B updated

defaultuser · 01-31-2012, 05:45 PM

...

Jawed · 01-31-2012, 05:55 PM

Originally Posted by simonj

I'm not sure that works..let me clarify

in cell B1 I want to put =B1+A1, so that B1 keeps a running total (sum) of all the numbers that were in A1 (ie. whenever A1 changes, it's added to B1)

It seems B1 contains a constant figure plus A1 that is ever changing. I agree, creating a third cell should resolve your problem.

simonj · 01-31-2012, 07:48 PM

Originally Posted by Jawed

It seems B1 contains a constant figure plus A1 that is ever changing. I agree, creating a third cell should resolve your problem.

B1 is not constant, it keeps a running total of all the numbers that have been in A1. (that's why I want it to equal what it was, plus the new figure)
????: NamePros.com http://www.namepros.com/showthread.php?t=745213
The previous poster was correct

Roos · 02-10-2012, 10:38 AM

you need to put the forumula in another cell e.g in c1 put =a1 + b1

01-31-2012, 01:50 PM	THREAD STARTER #1 (permalink)
simonj NamePros Regular Join Date: Jan 2005 Posts: 433	sorry for asking this but... This is probably the wrong place to ask but I have an excel problem that is driving me crazy. I need a formula to add another cell's contents to this cell. in programming it would be something like a=a+b but in excel it creates a circular error. Are there variables in excel, or another simple way of doing this? __________________ www.VWNG.com - Very Wise Name Generator

01-31-2012, 01:53 PM	#2 (permalink)
*Corey* Business Member Join Date: Mar 2008 Location: Australia Posts: 4,214	use brackets eg a=(a+b) __________________ ☆ Occupy.TV website/domain name for sale!

01-31-2012, 02:01 PM	THREAD STARTER #3 (permalink)
simonj NamePros Regular Join Date: Jan 2005 Posts: 433	I'm not sure that works..let me clarify in cell B1 I want to put =B1+A1, so that B1 keeps a running total (sum) of all the numbers that were in A1 (ie. whenever A1 changes, it's added to B1) __________________ www.VWNG.com - Very Wise Name Generator

01-31-2012, 05:45 PM	#6 (permalink)
defaultuser Senior Member Join Date: May 2009 Location: internet@ctivist.com Posts: 4,790	... __________________ A Member of: IdeationTeam.com HowToBeADomainer.com - a Domaining How To AuthorEditor.com Last edited by defaultuser; 02-12-2012 at 11:02 PM.

02-10-2012, 10:38 AM	#9 (permalink)
Roos New Member Join Date: Dec 2010 Posts: 12	you need to put the forumula in another cell e.g in c1 put =a1 + b1 __________________ Real Estate Spain

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)