Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help for using a range of cells!
Hi All,
I have a workbook that has multiple sheets. Each sheet/tab has a different project name but the cells A:13 - A:19 on each sheet all refer to team members names. On a new worksheet w/in the workbook I want have a list of team members names in Column A and want to add in the number of times their name appears w/in cells A:13-A:19 across all worksheets. For Example: Multi Sheets have the following names in the range of cells: John Mike Chris Chris shows up 5 times total throughout all the sheets so on the New Sheet "Resources" I want it to look like this: Column A Column B John 0 Mike 0 Chris 5 - this is a sum of the number of times "Chris" was listed in the cells across all the worksheets. Help!! It may be simple, but I am stuck in the mud.... Thanks in advance! |
#2
|
|||
|
|||
It could be very simple *if* you assigned each name to the same cell on each
sheet. It doesn't appear too difficult, since you mention only 6 cells (A13:A19), and I presume there are *only* 6 names to populate those cells. If my assumption is correct, and you could *always* enter: John A13 Mike A14 Chris A15 .... etc. Then this formula could total a particular cell across *all* the sheets. =SUM(Sheet1:Sheet15!A13) =SUM(Sheet1:Sheet15!A14) =SUM(Sheet1:Sheet15!A15) If you have elaborate names for your sheets, you could simply insert a Blank sheet at the beginning and end of the WB, and name them "Start" and "End" (no quotes), and use this formula: =SUM(Start:End!A13) Where the sheets *physically* in between the Start and End sheets will be totaled. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Sukismomma" wrote in message ... Hi All, I have a workbook that has multiple sheets. Each sheet/tab has a different project name but the cells A:13 - A:19 on each sheet all refer to team members names. On a new worksheet w/in the workbook I want have a list of team members names in Column A and want to add in the number of times their name appears w/in cells A:13-A:19 across all worksheets. For Example: Multi Sheets have the following names in the range of cells: John Mike Chris Chris shows up 5 times total throughout all the sheets so on the New Sheet "Resources" I want it to look like this: Column A Column B John 0 Mike 0 Chris 5 - this is a sum of the number of times "Chris" was listed in the cells across all the worksheets. Help!! It may be simple, but I am stuck in the mud.... Thanks in advance! |
#3
|
|||
|
|||
Hello!
I wish it were that simple and my apologies for not making the example broader. I do have only the 6 cells but I have about 45 resource names. I don't want to have 45 blank cells on each sheet for each of the resource to match to. Maybe I missed something in your explaination if that wouldn't be the case. Please correct me if I am misstating your response, Thank you! "RagDyer" wrote: It could be very simple *if* you assigned each name to the same cell on each sheet. It doesn't appear too difficult, since you mention only 6 cells (A13:A19), and I presume there are *only* 6 names to populate those cells. If my assumption is correct, and you could *always* enter: John A13 Mike A14 Chris A15 .... etc. Then this formula could total a particular cell across *all* the sheets. =SUM(Sheet1:Sheet15!A13) =SUM(Sheet1:Sheet15!A14) =SUM(Sheet1:Sheet15!A15) If you have elaborate names for your sheets, you could simply insert a Blank sheet at the beginning and end of the WB, and name them "Start" and "End" (no quotes), and use this formula: =SUM(Start:End!A13) Where the sheets *physically* in between the Start and End sheets will be totaled. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Sukismomma" wrote in message ... Hi All, I have a workbook that has multiple sheets. Each sheet/tab has a different project name but the cells A:13 - A:19 on each sheet all refer to team members names. On a new worksheet w/in the workbook I want have a list of team members names in Column A and want to add in the number of times their name appears w/in cells A:13-A:19 across all worksheets. For Example: Multi Sheets have the following names in the range of cells: John Mike Chris Chris shows up 5 times total throughout all the sheets so on the New Sheet "Resources" I want it to look like this: Column A Column B John 0 Mike 0 Chris 5 - this is a sum of the number of times "Chris" was listed in the cells across all the worksheets. Help!! It may be simple, but I am stuck in the mud.... Thanks in advance! |
#4
|
|||
|
|||
You understood my response very well.
I'm sorry that I don't have a suggestion for your particular scenario. XL is not too strong on 3D computation. Maybe someone else will have a suggestion for you. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Sukismomma" wrote in message ... Hello! I wish it were that simple and my apologies for not making the example broader. I do have only the 6 cells but I have about 45 resource names. I don't want to have 45 blank cells on each sheet for each of the resource to match to. Maybe I missed something in your explaination if that wouldn't be the case. Please correct me if I am misstating your response, Thank you! "RagDyer" wrote: It could be very simple *if* you assigned each name to the same cell on each sheet. It doesn't appear too difficult, since you mention only 6 cells (A13:A19), and I presume there are *only* 6 names to populate those cells. If my assumption is correct, and you could *always* enter: John A13 Mike A14 Chris A15 .... etc. Then this formula could total a particular cell across *all* the sheets. =SUM(Sheet1:Sheet15!A13) =SUM(Sheet1:Sheet15!A14) =SUM(Sheet1:Sheet15!A15) If you have elaborate names for your sheets, you could simply insert a Blank sheet at the beginning and end of the WB, and name them "Start" and "End" (no quotes), and use this formula: =SUM(Start:End!A13) Where the sheets *physically* in between the Start and End sheets will be totaled. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Sukismomma" wrote in message ... Hi All, I have a workbook that has multiple sheets. Each sheet/tab has a different project name but the cells A:13 - A:19 on each sheet all refer to team members names. On a new worksheet w/in the workbook I want have a list of team members names in Column A and want to add in the number of times their name appears w/in cells A:13-A:19 across all worksheets. For Example: Multi Sheets have the following names in the range of cells: John Mike Chris Chris shows up 5 times total throughout all the sheets so on the New Sheet "Resources" I want it to look like this: Column A Column B John 0 Mike 0 Chris 5 - this is a sum of the number of times "Chris" was listed in the cells across all the worksheets. Help!! It may be simple, but I am stuck in the mud.... Thanks in advance! |
#5
|
|||
|
|||
Ok. Thank you for your suggestion and I appreciate your time.
"RagDyer" wrote: You understood my response very well. I'm sorry that I don't have a suggestion for your particular scenario. XL is not too strong on 3D computation. Maybe someone else will have a suggestion for you. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Sukismomma" wrote in message ... Hello! I wish it were that simple and my apologies for not making the example broader. I do have only the 6 cells but I have about 45 resource names. I don't want to have 45 blank cells on each sheet for each of the resource to match to. Maybe I missed something in your explaination if that wouldn't be the case. Please correct me if I am misstating your response, Thank you! "RagDyer" wrote: It could be very simple *if* you assigned each name to the same cell on each sheet. It doesn't appear too difficult, since you mention only 6 cells (A13:A19), and I presume there are *only* 6 names to populate those cells. If my assumption is correct, and you could *always* enter: John A13 Mike A14 Chris A15 .... etc. Then this formula could total a particular cell across *all* the sheets. =SUM(Sheet1:Sheet15!A13) =SUM(Sheet1:Sheet15!A14) =SUM(Sheet1:Sheet15!A15) If you have elaborate names for your sheets, you could simply insert a Blank sheet at the beginning and end of the WB, and name them "Start" and "End" (no quotes), and use this formula: =SUM(Start:End!A13) Where the sheets *physically* in between the Start and End sheets will be totaled. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Sukismomma" wrote in message ... Hi All, I have a workbook that has multiple sheets. Each sheet/tab has a different project name but the cells A:13 - A:19 on each sheet all refer to team members names. On a new worksheet w/in the workbook I want have a list of team members names in Column A and want to add in the number of times their name appears w/in cells A:13-A:19 across all worksheets. For Example: Multi Sheets have the following names in the range of cells: John Mike Chris Chris shows up 5 times total throughout all the sheets so on the New Sheet "Resources" I want it to look like this: Column A Column B John 0 Mike 0 Chris 5 - this is a sum of the number of times "Chris" was listed in the cells across all the worksheets. Help!! It may be simple, but I am stuck in the mud.... Thanks in advance! |
#6
|
|||
|
|||
Perhaps you might try one of the programming groups.
I'm sure this can be accomplished with some code. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sukismomma" wrote in message ... Ok. Thank you for your suggestion and I appreciate your time. "RagDyer" wrote: You understood my response very well. I'm sorry that I don't have a suggestion for your particular scenario. XL is not too strong on 3D computation. Maybe someone else will have a suggestion for you. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Sukismomma" wrote in message ... Hello! I wish it were that simple and my apologies for not making the example broader. I do have only the 6 cells but I have about 45 resource names. I don't want to have 45 blank cells on each sheet for each of the resource to match to. Maybe I missed something in your explaination if that wouldn't be the case. Please correct me if I am misstating your response, Thank you! "RagDyer" wrote: It could be very simple *if* you assigned each name to the same cell on each sheet. It doesn't appear too difficult, since you mention only 6 cells (A13:A19), and I presume there are *only* 6 names to populate those cells. If my assumption is correct, and you could *always* enter: John A13 Mike A14 Chris A15 .... etc. Then this formula could total a particular cell across *all* the sheets. =SUM(Sheet1:Sheet15!A13) =SUM(Sheet1:Sheet15!A14) =SUM(Sheet1:Sheet15!A15) If you have elaborate names for your sheets, you could simply insert a Blank sheet at the beginning and end of the WB, and name them "Start" and "End" (no quotes), and use this formula: =SUM(Start:End!A13) Where the sheets *physically* in between the Start and End sheets will be totaled. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Sukismomma" wrote in message ... Hi All, I have a workbook that has multiple sheets. Each sheet/tab has a different project name but the cells A:13 - A:19 on each sheet all refer to team members names. On a new worksheet w/in the workbook I want have a list of team members names in Column A and want to add in the number of times their name appears w/in cells A:13-A:19 across all worksheets. For Example: Multi Sheets have the following names in the range of cells: John Mike Chris Chris shows up 5 times total throughout all the sheets so on the New Sheet "Resources" I want it to look like this: Column A Column B John 0 Mike 0 Chris 5 - this is a sum of the number of times "Chris" was listed in the cells across all the worksheets. Help!! It may be simple, but I am stuck in the mud.... Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions |