If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting formula help needed!
I'm attempting to do a spreadsheet to show our turnover data. I have sheets
titled Terms, Hires, 1st Shift, 2nd Shift and 3rd Shift. My terms and hires sheets have a columns for name, shift and month of term/hire. My shift sheets have the months listed down the left side. I need a formula to count the number of 1st, 2nd and 3rd shift employees termed/hired in each month (i.e. count the number of 1's in the shift column and 1's in the month column, etc.). Once I have the initial formula, I can copy and make changes where needed. I've tried everything I can think of and just can't seem to get it to work. Thanks in advance! Robin |
#2
|
|||
|
|||
Counting formula help needed!
Your description is very general so all I can give you is avery general
answer. It sounds like you are doing a count if with multiple criteria. Sumproduct is probalby the best way to go... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Robin" wrote: I'm attempting to do a spreadsheet to show our turnover data. I have sheets titled Terms, Hires, 1st Shift, 2nd Shift and 3rd Shift. My terms and hires sheets have a columns for name, shift and month of term/hire. My shift sheets have the months listed down the left side. I need a formula to count the number of 1st, 2nd and 3rd shift employees termed/hired in each month (i.e. count the number of 1's in the shift column and 1's in the month column, etc.). Once I have the initial formula, I can copy and make changes where needed. I've tried everything I can think of and just can't seem to get it to work. Thanks in advance! Robin |
#3
|
|||
|
|||
Counting formula help needed!
Here's some more info -- This is the "Terms" spreadsheet that I'm working off
of (the "Hires" sheet is identical). Both have name columns that I have hidden for this purpose. Shift Term Month 1 2 1 1 1 1 2 1 3 1 1 2 1 2 2 2 1 2 1 2 3 2 2 2 3 2 3 2 3 2 I need a formula to pull all of the 1st shift terms and hires into this sheet (in the same workbook): Month Terms Hires Jan 0 Feb March April May June July Aug Sept Oct Nov Dec As you can see, the formula should be pulling 2 terms in the month of Jan and 5 for the month of Feb. I have a separate sheet (again in the same workbook) for each shift. Hope that gives you a better idea of what I'm trying to accomplish. I appreciate the help! "Jim Thomlinson" wrote: Your description is very general so all I can give you is avery general answer. It sounds like you are doing a count if with multiple criteria. Sumproduct is probalby the best way to go... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Robin" wrote: I'm attempting to do a spreadsheet to show our turnover data. I have sheets titled Terms, Hires, 1st Shift, 2nd Shift and 3rd Shift. My terms and hires sheets have a columns for name, shift and month of term/hire. My shift sheets have the months listed down the left side. I need a formula to count the number of 1st, 2nd and 3rd shift employees termed/hired in each month (i.e. count the number of 1's in the shift column and 1's in the month column, etc.). Once I have the initial formula, I can copy and make changes where needed. I've tried everything I can think of and just can't seem to get it to work. Thanks in advance! Robin |
Thread Tools | |
Display Modes | |
|
|