Pat:
1. Where do I enter Total =Sum(D2:D500) ? The "name box", the "formula bar"
or some other location? Do I click on a cell to select it before entering
Total =Sum(D2:D500) in the location you will specify?

2. Your sugggestion of puttting the running totals above the entered data
makes sense, Pat. Where do I put =Sum(H2:H1000 or whatever)? \
Do I click on H1 to select it, then enter =Sum(H2:H1000 or whatever) in the
formula bar?


Thanks.
WC

"Pat Flynn" wrote:

Columns

Total =Sum(D2:D500) This will give you the sum of
D-repeat for E,F,G
Freeze Pane in cell A
A B C D E F G
Text Text Text Num Num Num Sum of D,E,F =Sum(D2:F2) (dopy this down
through column "G"

Hope this works for you.
Pat

"Wiley C" wrote:

Pat:
Thank for the reply.

"G" =SUM(D2:F2)
Will this give me a sum of only row 2, or of each row?

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.

Thanks. I'll give it a try & post my results.

WC

"Pat Flynn" wrote:

"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