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

COUNTIF across worksheets 3
Excel Need Countifs Formula Help 0
Countifs for multiple worksheets 4
Countif with a Range of criteria 8
Count multiple criteria 7
COUNTIF 3
Possible to refer to a sheet's object name ? 1
Finding the weighted average of text that have been given values 1

Top