Re: countif with criteria range (excel 2000)

Re: countif with criteria range (excel 2000)

What if I want to use a cell reference in place of the absolute criterion value? Something like:
=COUNTIF(Range,"<sheet2!A10")
Another post gave me the hint to add an "=" sign after the quote, thus:
=COUNTIF(Range,"=<sheet2!A10")
and that helps in that XL swallows the formula as a valid formula but it doesn't give me the correct count.