=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&{1,2,3,4}&"' !"&CELL("address",Z100)),"0"))

Of course this kind of formula will only work if your sheetnames fall into a
pattern like:

Sheet1
Sheet2
etc.

Use your own criteria in place of "0"
--
Gary''s Student - gsnu200786


"JStiehl" wrote:

Is it possible to use the COUNTIF function with data from different sheets?
Please help with proper syntax if possible. Thanks.