Thread: how do I include multiple worksheets to a countif formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default how do I include multiple worksheets to a countif formula?
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:A 100,"abc")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 19 Aug 2009 13:36:11 -0700, Brigette
wrote:

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?
Reply With QuoteReply With Quote