Using COUNTIF across different sheets

J

JStiehl

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

Gary''s Student

=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"
 
Top