CountIf

O

ordnance1

Is it possible to set a CountIf criteria across more than 1 worksheet? I
want to find all occurances of the word John across all 5 worksheets.
 
R

Ron Rosenfeld

Is it possible to set a CountIf criteria across more than 1 worksheet? I
want to find all occurances of the word John across all 5 worksheets.
Click to expand...

Download and install Laurent Longre's free morefunc.xll add-in and use the
COUNTIF.3D function.

1. This does not seem to work in Excel 2007, but works in earlier versions.
2. The usual download site is intermittently non-functional; you may have to
do a google search to find a good site.
--ron
 

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

Finding the weighted average of text that have been given values 1
COUNTIF across worksheets 3
Excel Countif Function - Calculating Between Two Sets of Values 3
Counting multiple occcurrences between date range 3
Excel 2010 countifs for date range 3
Possible to refer to a sheet's object name ? 1
countifs Function not giving desired result with date criteria 2
Countifs for multiple worksheets 4

Top