Excel Table Autofill Formula

Hello,

I have an Excel table that I've used for weeks now with no problems. Now, however, the autofill of one specific formula is acting strangely and I'm really not sure what is causing it. All of the other formulas are updating and referencing correctly. The weird behavior is that as the next row populates, the reference location is either becoming locked or it completely skips the reference and moves to the next. For instance:

=COUNTIF($G$2:G4647,G4647)=1

=COUNTIF($G$2:G4648,G4648)=1

=COUNTIF($G$2:G4650,G4649)=1

=COUNTIF($G$2:G4650,G4650)=1

The super strange thing is that if I add another row and do absolutely nothing else, the problem formula updates and the formulas look like this!

=COUNTIF($G$2:G4647,G4647)=1

=COUNTIF($G$2:G4648,G4648)=1

=COUNTIF($G$2:G4651,G4649)=1

=COUNTIF($G$2:G4651,G4650)=1

=COUNTIF($G$2:G4651,G4651)=1

Additionally, it goes back and randomly messes up other formulas that were correct.
=COUNTIF($G$2:G4651,G4621)=1
=COUNTIF($G$2:G4651,G4622)=1
=COUNTIF($G$2:G4651,G4623)=1
=COUNTIF($G$2:G4651,G4629)=1

I verified that all other formulas in the row are consistent. Has anyone ever seen this before and have a workaround? I am ready to just use vba to fill down everytime a new row is added but would like to figure out the problem rather than bandaiding it.

Thanks!

Edit: The only thing different about this formula than the rest is that the range contains an absolute reference and relative reference. I found that if I changed the entire range to relative that the bug goes away. But this makes the formula useless.