CountIf

ordnance1 · Dec 24, 2008

Is it possible to use CountIf across multiple worksheets? So if I want to
count the number of occurances of John across sheets 1 through 10.

JE McGimpsey · Dec 25, 2008

One way:

See

http://mcgimpsey.com/excel/threedsumif.html

(use COUNTIF instead of SUMIF, obviously).