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
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