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 |
#2
|
|||
|
|||
"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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
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) |