how do I include multiple worksheets to a countif formula?

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?
 
C

Chip Pearson

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)
 

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 on multiple criteria 1
Using <= in countifs statement 1
Mac Countif function not working at all 0
Embed the same Excel multiple times 0
countif function 6
need help in fine-tuning a formula that removes blank cells in a column range 3
Countif formula 2
office 2007 -- formulas 1

Top