Hi all,
I have a workbook that logs daily production totals. I am able to count totals for production between dates but for the life of me are unable to figure out how to count the employees. I'm using
=SUMIFS(DataBase!H:H,DataBase!A:A,">="&$P$1,DataBase!A:A,"<="&$P$2,DataBase!S:S,O4)
to locate totals. A:A is the date location and H:H is the totals production. S:S is where the matching data is located for O4.
Sometimes the names appear twice on the same date on the DataBase tab. I would like to receive a count of how many names (not duplicated) fall between the dates I set in P1 and P2.
The names are located in column B:B
Thanks for any help.
I have a workbook that logs daily production totals. I am able to count totals for production between dates but for the life of me are unable to figure out how to count the employees. I'm using
=SUMIFS(DataBase!H:H,DataBase!A:A,">="&$P$1,DataBase!A:A,"<="&$P$2,DataBase!S:S,O4)
to locate totals. A:A is the date location and H:H is the totals production. S:S is where the matching data is located for O4.
Sometimes the names appear twice on the same date on the DataBase tab. I would like to receive a count of how many names (not duplicated) fall between the dates I set in P1 and P2.
The names are located in column B:B
Thanks for any help.
