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

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

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