Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
quattro converter for Excel 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |