Countif formula not working

[thechad]

Hi all,

I am having a problem with a countif formula and am losing my mind. I have a (i.e. Range A) range of columns and rows with data and column A is formatted as General and contains a list of 9 digit numbers. I have another range (i.e. Range B) that also has columns and rows of data and it also has a column that is formatted as General and also contains a list of 9 digit numbers. I am using the countif formula to search the Range A column with the list of 9 digit numbers to see how many times the same value shows up in Range B in a similarly formatted column with a list of 9 digit numbers. I know there are duplicate between the 2 ranges but nothing is showing up with the countif formula. Excel shows the columns in both ranges are formatted identically but for whatever reason it isn't working. I could really use some help because about losing my freakin' mind here!!!!!

Thanks!

 

[Proulxs]

Could you provide us with the formula you are using?
=countif(RangeA;B1) and you dragged this all the way down for all data in B? (or vice versa)

 

[thechad]

here is the formula: =COUNTIF(Sheet1!$A$2:$A$15000, page!G2)

And I did drag it down the entire column in Range B.