Hello, please help me understand why this COUNTIF formula returns a different value but it the same formula throughout.
There are a total of 631 items in Table4. Table4 are in cells A2:G633. The formula =COUNTIF(Table4[Column4],"="&Table4[Column3]) is in cell J4 which returns 476, the correct...