JessWhyCuh
New Member
- Joined
- Jul 10, 2018
- Messages
- 15
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 value. When I copy/paste this formula in the cell J1, for example, it returns the value 0 which is incorrect. In other cells, the number changes to 86, 0, 8, 25, and other incorrect values. I'm wondering if anyone knows why? I'm trying to move this formula to be outside the same rows as Table4 so when the table is filtered I can still see this COUNTIF value rather than have it hidden.
Thanks!
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 value. When I copy/paste this formula in the cell J1, for example, it returns the value 0 which is incorrect. In other cells, the number changes to 86, 0, 8, 25, and other incorrect values. I'm wondering if anyone knows why? I'm trying to move this formula to be outside the same rows as Table4 so when the table is filtered I can still see this COUNTIF value rather than have it hidden.
Thanks!
