Adding two Columns
 

I have an open workbook with mulitiple sheets. I want to create a column "F"
that will keep track of all transactions made in column "E". e.g
"E" "F"
Amount $ Balance
$5,000.00 $5,000.00
-$0.04 $4,999.96
$3.89 $5,003.85
$24,000.00 $29,003.85
$21,000.00 $50,003.85
$16,000.00 $66,003.85

However, as of right now, I have to manually add/subtract "E" and then type
it in to "F". What can I do to have this done automatically? I am falling way
behind in doing this manually and need to catch up/remain current on 50+
pages, and counting.

Adding two Columns
 

You could try this for col F
In F2: =E2
In F3: =IF(E3="","",SUM(F2,E3))
Copy F3 down as far as required

If above helps, press the YES button to "high five" this response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Gr8 Dane" wrote:
I have an open workbook with mulitiple sheets. I want to create a column "F"
that will keep track of all transactions made in column "E". e.g
"E" "F"
Amount $ Balance
$5,000.00 $5,000.00
-$0.04 $4,999.96
$3.89 $5,003.85
$24,000.00 $29,003.85
$21,000.00 $50,003.85
$16,000.00 $66,003.85

However, as of right now, I have to manually add/subtract "E" and then type
it in to "F". What can I do to have this done automatically? I am falling way
behind in doing this manually and need to catch up/remain current on 50+
pages, and counting.

Adding two Columns
 

Max... I did that. But in every F cell, it gave the same answer and that was
the sum of the first. 4999.96. How do I do this so that it changes SUM(F*,E*)?

"Max" wrote:

You could try this for col F
In F2: =E2
In F3: =IF(E3="","",SUM(F2,E3))
Copy F3 down as far as required

If above helps, press the YES button to "high five" this response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Gr8 Dane" wrote:
I have an open workbook with mulitiple sheets. I want to create a column "F"
that will keep track of all transactions made in column "E". e.g
"E" "F"
Amount $ Balance
$5,000.00 $5,000.00
-$0.04 $4,999.96
$3.89 $5,003.85
$24,000.00 $29,003.85
$21,000.00 $50,003.85
$16,000.00 $66,003.85

However, as of right now, I have to manually add/subtract "E" and then type
it in to "F". What can I do to have this done automatically? I am falling way
behind in doing this manually and need to catch up/remain current on 50+
pages, and counting.

Adding two Columns
 

As responded in your other thread ...
---------
It should work fine ..

a. Check that calc mode is not set to manual:
Click Tools Options Calculation tab
Check "Automatic" OK

b. If it isn't calc mode, then your data in col E probably contains text
nums, not real nums (or a mix). Convert the source data at one go to all real
nums like this. Copy any empty cell, select col E, right-click paste
special check "Add" ok. That should do it ok, and all should compute
properly now.

p/s: Remember to "high five" ALL responses which help, press the YES buttons
below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Gr8 Dane" wrote:
Max... I did that. But in every F cell, it gave the same answer and that was
the sum of the first. 4999.96. How do I do this so that it changes SUM(F*,E*)?