compare two columns of data, excel 97 array
Posted by ken thompson on August 05, 2000 7:11 AM
I need to compare two columns of data and get a total count in one cell.
B1:B50 will be mixed with either night or day shift.
C1:C50 will be dates during 4-1-00,5-1-00 or 6-1-00.
I tried to get a total count of night workers during a particular month(april)
using a combination of array, sum(if(B1:B50,"night"
but I'm unable to complete it.
your help would be appreciated,
thank you, ken