CountIf

  • Thread starter Thread starter ordnance1
  • Start date Start date
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.
 
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
 
Back
Top