excel 2003 questions
 

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