=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,