Sum

[Bob]

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

 

[Bob Phillips]

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

and copy down

 

[JR Form]

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]

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]

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.

 

[Matt S]

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