=COUNTIF / =COUNTIFS Not working

[something68]

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.

 

[Fluff]

Try it like

=countifs($o3:$s3,b3)

 

[something68]

Try it like

=countifs($o3:$s3,b3)

Thank you, but I'm afraid that did not work. It didn't seem to pick up the number 13 in cell C15.

 

[Fluff]

That's because there is no 13 in cols O:S on that row.

 

[something68]

My apologies, I did not include column N in the formula. It picked up the 13.


Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.