Need Help to COUNTIFS across multiple sheets/same column

Hi,

I have VBA for countif formula :

Function myCountIf(rng As Range, criteria) As Long
    Dim ws As Worksheet

    For Each ws In ThisWorkbook.Worksheets
        myCountIf = myCountIf + WorksheetFunction.CountIf(ws.Range(rng.Address), criteria)
    Next ws
End Function

I need to make it to countifs, cause i have mutiple criteria to count, anyone can help?


Thanx.