|Unfortunately, COUNTIF does not work across multiple sheets.|
If you DAGS countif multiple sheets you'll find some options.
One simple method is brute force:
There are also some UDF (User Defined Functions) written in VBA that are much easier to use, as long as using VBA fits in your environment.
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)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.