Countin Numbers in a Workbook

[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?

 

[Domenic]

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

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

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

Hope this helps!