something68
New Member
- Joined
- Sep 13, 2024
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I am having trouble getting the =COUNTIF / =COUNTIFS to work properly.
Here is what I'm doing - =countif(b3:f3,o3:s3) OR =countifs(b3:f3,o3:s3). It will highlight some numbers that match in those columns and other numbers that need to be matched are not highlighted. Example below: row 27 should have 13, 32, and 46 highlighted since they match numbers in columns O, R and S but it is hightlighting 01 (in column B) that is not in any of the columns O3:S:3.
Here is what I'm doing - =countif(b3:f3,o3:s3) OR =countifs(b3:f3,o3:s3). It will highlight some numbers that match in those columns and other numbers that need to be matched are not highlighted. Example below: row 27 should have 13, 32, and 46 highlighted since they match numbers in columns O, R and S but it is hightlighting 01 (in column B) that is not in any of the columns O3:S:3.