Sum
 

I'm pretty inexperienced with Excel, I just want to know if there's an easy
way to use the sum function to add the cell above it into the equation, so
for example
A B
+5 10
-4 6

Basically I just want a running total in columb B but there are going to be
a lot of entries, so I was wondering if there was a way to format column B to
keep a running total of A.
Thanks!
Bob

Sum
 

B1: = SUM($A$1:$A1)

and copy down

--
__________________________________
HTH

Bob

"Bob" wrote in message
...
I'm pretty inexperienced with Excel, I just want to know if there's an
easy
way to use the sum function to add the cell above it into the equation, so
for example
A B
+5 10
-4 6

Basically I just want a running total in columb B but there are going to
be
a lot of entries, so I was wondering if there was a way to format column B
to
keep a running total of A.
Thanks!
Bob

Sum
 

Bob,

Assuming you start at cloumn b, row 2, insert this formula and then copy it
down the page.

in row B2 put =A2
in row B3 put =B2+A3

if you want to be sure there a number thier then do this formula

=IF(ISNUMBER(A2),B2+A3,"")
it will leave it blank if there no number or if there is text.


"Bob" wrote:

I'm pretty inexperienced with Excel, I just want to know if there's an easy
way to use the sum function to add the cell above it into the equation, so
for example
A B
+5 10
-4 6

Basically I just want a running total in columb B but there are going to be
a lot of entries, so I was wondering if there was a way to format column B to
keep a running total of A.
Thanks!
Bob

Sum
 

I understand that, but I'm wondering if there's a way to format row B, so
that every cell is a summation of the one above it and to the left of it,
without having to go thru each cell and inserting that formula.

"JR Form" wrote:

Bob,

Assuming you start at cloumn b, row 2, insert this formula and then copy it
down the page.

in row B2 put =A2
in row B3 put =B2+A3

if you want to be sure there a number thier then do this formula

=IF(ISNUMBER(A2),B2+A3,"")
it will leave it blank if there no number or if there is text.


"Bob" wrote:

I'm pretty inexperienced with Excel, I just want to know if there's an easy
way to use the sum function to add the cell above it into the equation, so
for example
A B
+5 10
-4 6

Basically I just want a running total in columb B but there are going to be
a lot of entries, so I was wondering if there was a way to format column B to
keep a running total of A.
Thanks!
Bob

Sum
 

Bob,

I am not aware of a 'format' that is equal to a formula. You can 'format'
a column to be numbers or text but what you want is a formula.



"Bob" wrote:

I understand that, but I'm wondering if there's a way to format row B, so
that every cell is a summation of the one above it and to the left of it,
without having to go thru each cell and inserting that formula.

"JR Form" wrote:

Bob,

Assuming you start at cloumn b, row 2, insert this formula and then copy it
down the page.

in row B2 put =A2
in row B3 put =B2+A3

if you want to be sure there a number thier then do this formula

=IF(ISNUMBER(A2),B2+A3,"")
it will leave it blank if there no number or if there is text.


"Bob" wrote:

I'm pretty inexperienced with Excel, I just want to know if there's an easy
way to use the sum function to add the cell above it into the equation, so
for example
A B
+5 10
-4 6

Basically I just want a running total in columb B but there are going to be
a lot of entries, so I was wondering if there was a way to format column B to
keep a running total of A.
Thanks!
Bob

Sum
 

Bob,

You do not have to type the formula in every cell... just type it in the
first one and then do the autofill. It copies that formula down. There's a
black box on the bottom right hand corner of the cell when highlighted that
allows you to either double-click to autofill, or you can grab that box and
drag it down manually. If you need to make a cell constant, add dollar
signs, such as $A$1.

Good luck!
Matt


"Bob" wrote:

I understand that, but I'm wondering if there's a way to format row B, so
that every cell is a summation of the one above it and to the left of it,
without having to go thru each cell and inserting that formula.

"JR Form" wrote:

Bob,

Assuming you start at cloumn b, row 2, insert this formula and then copy it
down the page.

in row B2 put =A2
in row B3 put =B2+A3

if you want to be sure there a number thier then do this formula

=IF(ISNUMBER(A2),B2+A3,"")
it will leave it blank if there no number or if there is text.


"Bob" wrote:

I'm pretty inexperienced with Excel, I just want to know if there's an easy
way to use the sum function to add the cell above it into the equation, so
for example
A B
+5 10
-4 6

Basically I just want a running total in columb B but there are going to be
a lot of entries, so I was wondering if there was a way to format column B to
keep a running total of A.
Thanks!
Bob