View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Adding Two Columns

F3: =F2+E3

and copy down

--
__________________________________
HTH

Bob

"Gr8 Dane" wrote in message
...
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.