please see the attached workbook.
on sheet 2 column C, i would like the formula to match the date in column A and the employee number in column B to the date and employee number on sheet 1 AND...
count the amount of times the conditions match the column header.
so for example, in cell C2 on sheet 2, i would like the amount of times employee number 1 on the 17/08/2013 had 1stfloor; bad; fast; and summer listed across a row.
in cell C3, id like the same thing but for employee 2.
columns D,E, and F do not need to be done. i put them in to help give an idea of what im doing.
thank you!!!
Bookmarks