"G" =SUM(D2:F2)
For keeping a running tally/sum of Column D,E,F,G I would set my sheet up
with a Totals row above my data (at the top of the sheet) Then employ
=Sum(H2:H1000 or whatever) This will give you a continuous sum. Now in
order not to have to scroll up to see the results place your cursor in your
1st data row (A3) go to WindowFreeze Panes. This will freeze your header
rows allowing you to see your sums while working in the "Pane" below adding
additional data.
Pat

"Wiley C" wrote:

Excel 2003, part of Office Professional 2003
Windows XP Pro SP2

Spreadsheet currently has text columns & data [ US $ ] columns.
Columns A, B, C have information about the contact
Data is in columns D, E, F
Column H notes the group to which the the contact belongs
I would like:
1. column G to equal a sum of columns D, E, F

2. the final row of columns D, E, F, G to equal the sum of the previous
rows of the corresponding columns. When I add another row, I would like the
new total to automatically appear. i.e., when I have information in rows 1 -
20, cell D21 will provide a sum of D1 - D20. When I add information to row
21; D22 will automatically sum cells D1 - D22.

3. the contacts of each group to be sent to a separate file / document /
spreadsheet, so that a mailing list can be created, by group.

Thanks for your help.

WC