countifs incorrect

[santamills]

I have 2 columns. Names are NAT_APP and NAT_BAS_Evidence
Both columns are GENERAL
I want to count where NAT_APP is "B" and NAT_BAS_Evidence is 6

Formula
=COUNTIFS(NAT_APP,"*B*",NAT_BAS_Evidence,"*6*")

If Column NAT_BAS_Evidence has a '6 it is counted but a 6 is not counted. Why??? I do not want to overtype every 6 in the raw data with a '6

 

[Jonmo1]

Wildcards don't work on numeric values.

Try either

=COUNTIFS(NAT_APP,"*B*",NAT_BAS_Evidence,6)
=COUNTIFS(NAT_APP,"*B*",NAT_BAS_Evidence,"6")

 

[FDibbins]

I do not want to overtype every 6 in the raw data with a '6

...
If you have a mix of '6 (text) and 6 (numeric), it would probably be to convert to just 1 type (numeric), anyway - always better to work with just 1 data type. You could do that pretty easily with Find/Replace