Countin Numbers in a Workbook

M

Matt

I am trying to find a funciton that counts the number of times a number shows
up in various locations in a worksheet and also on multiple worksheets within
a workbook.

I.E.
How many times does "171" appear in mutliple worksheets in one worbook?
 
D

Domenic

If the target ranges are located at the same place on each sheet, for
example D2:D100 on each sheet, try...

=SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$2:$A$4&"'!D2:D100"),"171"))

....where A2:A4 contains the sheet names.

Hope this helps!
 
Top