Finding data on another worksheet in same workbook...?

  • Thread starter Thread starter David Penney
  • Start date Start date
D

David Penney

Hello,

I previously had data on same worksheet as formula:

=COUNTIF(B99:B1000,A3)

and so on...

But now the data is on Worksheet named: "ItemList"

With again all the data being between B99 and B1000....

How do I now put the new worksheet into the formula above so that it will
get data from cells B99 to B1000 on worksheet named ItemList?

TIA

DP
 
Back
Top