how do I include multiple worksheets to a countif formula?

  • Thread starter Thread starter Brigette
  • Start date Start date
B

Brigette

I want to use a countif formula. the data I need is from multiple worksheets.
How can I use the countif function for the 2 worksheets?
 
You can't combine ranges from two separate worksheets and/or workbooks
into a single range. You'll need to use two separate COUNTIFs, one for
each sheet. E.g.,

=COUNTIF(Sheet1!A1:A100,"abc")+COUNTIF(Sheet2!A1:A100,"abc")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
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

Excel Count If Formula Question 1
Excel Need Countifs Formula Help 0
office 2007 -- formulas 1
Countif formula 2
COUNTIF Formula in Multiple worksheets. 14
Countif result problem 4
Countifs anchoring formula when sorting 1
Countif only once 4

Back
Top