=Subtotal(countif,Range); Subtotal and countif in 1 formula [SOLVED]

Goal: To get the total count per month of positions that have "0's" by department.

I have found that the subtotal function will be able to do the trick for me but it doesn't have the countif function with it (only has count and counta, I want countif)

I've searched boards and found this formula which from how i understood is the subset of the subtotal formula.

=SUMPRODUCT(SUBTOTAL(3, OFFSET(Range,ROW(Range)-MIN(ROW(Range)),0,1)),--(Range=Criteria))

The problem though, I don't know how to apply this.

I've attached the spreadsheet. Please refer to the orange highlight.

Any help appreciated!

Thanks,

To get the count of open positions for the filtered department, try this regular formula:
K28: =SUMPRODUCT(SUBTOTAL(2,OFFSET(K$4,ROW($4:$25)-4,))*(K$4:K$25=0)*($D$4:$D$25<>""))

copy that formula across through V28

Is that something you can work with?

Glad I could help.