Using COUNTIF across different sheets

  • Thread starter Thread starter JStiehl
  • Start date Start date
J

JStiehl

Is it possible to use the COUNTIF function with data from different sheets?
Please help with proper syntax if possible. Thanks.
 
=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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF across different spreadsheets 2
Excel Need Countifs Formula Help 0
Using COUNTIF across sheets 4
VBA Countif across sheets? 5
applying COUNTIF formula across several sheets 4
countif using two variable 8
Countif Function 3
COUNTIF, Sorting, on Two Sheets 1

Back
Top