Count # of occurrences in range

I'm looking for a function to count the number of times the cell A2 in Sheet7 occurs in the A column of sheet9. This does not work:

NumFu = Application.CountIf(Sheet9.Range("A:A"), Sheet7.Range("A2").Text)

Any ideas?

Thanks in advance

What is the value in Sheet7!A2? is it a date?

Im not sure why, but using the .Text property is giving inconsistent results, .Value is better

NumFu = Application.CountIf(Sheet9.Range("A:A"), Sheet7.Range("A2").Value)

Originally Posted by HalPlz

I'm looking for a function to count the number of times the cell A2 in Sheet7 occurs in the A column of sheet9. This does not work:

NumFu = Application.CountIf(Sheet9.Range("A:A"), Sheet7.Range("A2").Text)

Any ideas?

Thanks in advance

Instead of

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

you need to use

Please Login or Register  to view this content.

Cheers!!