Counting formula help needed!

R

Robin

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
 
R

Robin

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Help 1
Data Validation question 1
Complex Timesheet 10
Time calculation 3
Staff Levels 3
ISODD array formula 1
Formula returns #N/A 1
SUMPRODUCT with Date? 3

Top