Countif between 2 dates and multiple criteria

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

Please note, I need a running total of Active employees. On sheet2, I have all the data.

I created a formula that almost worked, but when I had to add a new Active employee, the totals from the previous weeks would count that employee as well.

On Sheet1, I manually added what the values should be based off the current data I have.

Hi

See if this help

To use multiple criteria you can use for example

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

where --(...) is other condition you want.

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:

Please Login or Register  to view this content.

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