Countif between 2 dates and multiple criteria

i don't understand

Originally Posted by Sasquatch2014

I need to count the total of a certain type of employee between the most recent 2 'week ending' dates on sheet 1.

For example, criteria for one of the countif formulas would contain:

SM
ORG
Week ending

...

To count the number of registers you have in Sheet2, with Role="SM", Dept="ORG", Status="Active"
you can use this
=SUMPRODUCT(--(Sheet2!$B$2:$B$500="SM")*--(Sheet2!$C$2:$C$500="ORG")*--(Sheet2!$D$2:$D$500="Active"))

Formula:

=SUMPRODUCT(--(Sheet2!$B$2:$B$500="SM")*--(Sheet2!$C$2:$C$500="ORG")*--(Sheet2!$D$2:$D$500="Active"))

What do you not understand?
I dont know wath field, in sheet 2, I have teste to perform Week ending. Can you clarify?
Regards