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