Countifs Error

[Huey462]

I have two columns of data, one is strictly numerical (other than the header) and the other displays a text string depending on the nested if. My problem is that I want to find the number of times each of the 3 text possibilities correspond to each numerical value.

Column D contains either 5, 6, or 7
Column L. contains either "Vacant', "SAR Match", or "SAR Mismatch"

the formula
=COUNTIFS(Merge!L:L,"Vacant",Merge!D:D,5)
returns "0" but a countif for "Vacant" and "5" return 24 and 3 respectively

I'm guessing the problem lies in counting a text and number combination. Is there a way around this issue?

 

[Jonmo1]

Sounds like the values in D are TEXT numbers.

=COUNTIFS(Merge!L:L,"Vacant",Merge!D:D,"5")

 

[Fluff]

Do any of your Vacant & 5 occur on the same row?

 

[Jonmo1]

returns "0" but a countif for "Vacant" and "5" return 24 and 3 respectively

That by itself doesn't mean the countifs will return a non 0 result.

Countifs will only count occurances where both criteria are true 'on the same row'

So if L2 = Vacant and D2 = 5, then it's counted
But if L5 = Vacant and D5 = 7, then it's not counted
And if L8 = SAR Match and D8 = 5, then it's not counted

 

[Huey462]

Apologies for the delayed reply.

There are matches and the problem was user error. I do appreciate the feedback