Excel Formula Use

Question

Hi ! In Excel, I have to figure out how to keep a line-by-line running $$ amount in one column, when entering $ amounts line-by-line in another column !!

Thanx! Tom :)

Answer 1

Hey !!

I figured it out!! It works!!

I used =SUM(E$2:E2) (NO B1 !!) and it worked!!!

Thanx for the help! I thought B1 was a part of the formula, but apparently, WASN'T !!

I can now use this formula for 2 other columns that I need (TAX and Running Tax Total !!)

If you has said 'Put the formula in cell B1', and NOT include B1 as part of the formula, it would have worked right off the bat!

Again, thanx for the help!!

Tom :)

Answer 2

Hiya !

I plugged in the formula ( B1: =SUM(A$1:A1) ) but switched the cells and lines to reflect what I was using! G2: =SUM(E$2:E2) . I had used line 1 to put in column titles ! I then dragged the formula down to line 500.

I saved the file, and when I reopened it, My column G (your B) had the formula I used in ALL the lines in cell G ! when I entered values in E, no values showed up in G !

Did I screw up?

I tried to get you a screen shot, but it didn't work! It said invalid file type!

Maybe you could send me a vid like the first one using E (Sales) and G (Running Total Sales) to see if I can get this!!!

If U give me your email, I'll send you a screenshot of my initial results!!

Thanx,

Tom :)

Answer 3

B2: =B1+A2

Or use

B1: =SUM(A$1:A1)

and drag down.