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

"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

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

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

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

Wiley,
You can put them anywhere you want. I would suggest that you try to keep
them in the same column above your data. The freeze pane has to be below them
for it to work nicely. Or you could keep them running totals off to the top
right side of your data headings. This works ok if your spreadsheet is not
very wide.
Pat

"Wiley C" wrote:

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

Pat:
Thanks for the reply.
Your knowledge base is way above mine.

I know how to enter text, date & currency. I know how to use the sum /
sigma feature. I know how to freeze a row.

Perhaps you could provide step by step instructions or point me to a book or
website.

I'm a real beginner.

WC

"Pat Flynn" wrote:

Wiley,
You can put them anywhere you want. I would suggest that you try to keep
them in the same column above your data. The freeze pane has to be below them
for it to work nicely. Or you could keep them running totals off to the top
right side of your data headings. This works ok if your spreadsheet is not
very wide.
Pat

"Wiley C" wrote:

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

Hi Wiley,
Glad I could help. I've been using Excel for years, and I feel like a real
beginner. The neat thing about Excel is tbere is virtually never just one
answer, method, function or formula to give you the output you desire. There
are normally many different ways to achieve the same output, and that is
where the learning really takes place in watching, networking and listening
to the ways others arrive at the same solution. Enjoy the learning process.
It goes on forever.
Pat

"Wiley C" wrote:

Pat:
Thanks for the reply.
Your knowledge base is way above mine.

I know how to enter text, date & currency. I know how to use the sum /
sigma feature. I know how to freeze a row.

Perhaps you could provide step by step instructions or point me to a book or
website.

I'm a real beginner.

WC

"Pat Flynn" wrote:

Wiley,
You can put them anywhere you want. I would suggest that you try to keep
them in the same column above your data. The freeze pane has to be below them
for it to work nicely. Or you could keep them running totals off to the top
right side of your data headings. This works ok if your spreadsheet is not
very wide.
Pat

"Wiley C" wrote:

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