ExcelBanter - CountIf

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - CountIf (https://www.excelbanter.com/excel-programming/421713-countif.html)

ordnance1

CountIf

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

CountIf

One way:

See

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

(use COUNTIF instead of SUMIF, obviously).

In article ,
ordnance1 wrote:

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.

All times are GMT +1. The time now is 10:01 AM.