Hello
I'm trying to add a number that was calculated by means of a formula in one
column to the sum of a different column.

Example:

Column A (running balance) Column B (sum)
=+e5+c6-d6 =sum(h1:h8)

Col A's number is running balance. I copied the formula down so that the
next row changes the formula to =+e6=c7-d7

I want that running balance to add to a sum in another column.
I can add the first cell to it, but it doesn't change if the running balance
changes. I know that is because it's pointing to that single cell and not the
formula.

Can this do what I want it to do?
Thanks for your help.

Not quite sure but if you want try this
=sum($h$1:h8)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Diane" wrote in message
...
Hello
I'm trying to add a number that was calculated by means of a formula in
one
column to the sum of a different column.

Example:

Column A (running balance) Column B (sum)
=+e5+c6-d6 =sum(h1:h8)

Col A's number is running balance. I copied the formula down so that the
next row changes the formula to =+e6=c7-d7

I want that running balance to add to a sum in another column.
I can add the first cell to it, but it doesn't change if the running
balance
changes. I know that is because it's pointing to that single cell and not
the
formula.

Can this do what I want it to do?
Thanks for your help.

Are you say that you have just one *sum* cell and you want to add the *last*
running balance figure in Column A?

If so the use:

=SUM(H1:H8)+LOOKUP(10^10,A1:A8)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Diane" wrote in message
...
Hello
I'm trying to add a number that was calculated by means of a formula in
one
column to the sum of a different column.

Example:

Column A (running balance) Column B (sum)
=+e5+c6-d6 =sum(h1:h8)

Col A's number is running balance. I copied the formula down so that the
next row changes the formula to =+e6=c7-d7

I want that running balance to add to a sum in another column.
I can add the first cell to it, but it doesn't change if the running
balance
changes. I know that is because it's pointing to that single cell and not
the
formula.

Can this do what I want it to do?
Thanks for your help.

Thank you for trying - no that didn't work. I was just throwing numbers out
for example. Here is a picture of the real spreadsheet. I'll use simple
numbers to get the point across.

C D E H
50 1
2 1 51 1
2 1 52 1
1
4 Total

The cells in Col E have a formula that I copied down the column so it
changes on each row E1+c2-d2

Column h is a list of numbers that are totalled at the bottom.

What I want to do is add the current total in Col E to the Total in col H.
I want the total to change as Column E changes . Column E would be the
variable number.
I can get the two numbers to add, but when I go to the next row and make
changes, the number stays the same. It just looks to the cell I originally
entered in the formula.
I hope I was a little clearer this time. I don't know what I'm trying to
say which makes your job a lot harder! LOL Thanks for trying!



"Don Guillett" wrote:


Not quite sure but if you want try this
=sum($h$1:h8)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Diane" wrote in message
...
Hello
I'm trying to add a number that was calculated by means of a formula in
one
column to the sum of a different column.

Example:

Column A (running balance) Column B (sum)
=+e5+c6-d6 =sum(h1:h8)

Col A's number is running balance. I copied the formula down so that the
next row changes the formula to =+e6=c7-d7

I want that running balance to add to a sum in another column.
I can add the first cell to it, but it doesn't change if the running
balance
changes. I know that is because it's pointing to that single cell and not
the
formula.

Can this do what I want it to do?
Thanks for your help.

Thank You!! that worked!!

"Sandy Mann" wrote:

Are you say that you have just one *sum* cell and you want to add the *last*
running balance figure in Column A?

If so the use:

=SUM(H1:H8)+LOOKUP(10^10,A1:A8)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Diane" wrote in message
...
Hello
I'm trying to add a number that was calculated by means of a formula in
one
column to the sum of a different column.

Example:

Column A (running balance) Column B (sum)
=+e5+c6-d6 =sum(h1:h8)

Col A's number is running balance. I copied the formula down so that the
next row changes the formula to =+e6=c7-d7

I want that running balance to add to a sum in another column.
I can add the first cell to it, but it doesn't change if the running
balance
changes. I know that is because it's pointing to that single cell and not
the
formula.

Can this do what I want it to do?
Thanks for your help.

Glad to help. Thanks for the feedback

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Diane" wrote in message
...

Thank You!! that worked!!

"Sandy Mann" wrote:

Are you say that you have just one *sum* cell and you want to add the
*last*
running balance figure in Column A?

If so the use:

=SUM(H1:H8)+LOOKUP(10^10,A1:A8)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Diane" wrote in message
...
Hello
I'm trying to add a number that was calculated by means of a formula in
one
column to the sum of a different column.

Example:

Column A (running balance) Column B (sum)
=+e5+c6-d6 =sum(h1:h8)

Col A's number is running balance. I copied the formula down so that
the
next row changes the formula to =+e6=c7-d7

I want that running balance to add to a sum in another column.
I can add the first cell to it, but it doesn't change if the running
balance
changes. I know that is because it's pointing to that single cell and
not
the
formula.

Can this do what I want it to do?
Thanks for your help.