CountIfs not returning value

[vladi305]

33

56

64

66

68

I have the following cells as shown above. They're all General data set

I wonder why it won't return true when it finds 56

=IF(COUNTIFS(B3:F3,">=43",B3:F3,"<=56")=0,"",COUNTIFS(B3:F3,">=43",B3:F3,"<=56"))

There are 5 formulas
=IF(COUNTIFS(B$3:F$3,">=1",B$3:F$3,"<=14")=0,"",COUNTIFS(B$3:F$3,">=1",B$3:F$3,"<=14"))
=IF(COUNTIFS(B3:F3,">=15",B3:F3,"<=28")=0,"",COUNTIFS(B3:F3,">=15",B3:F3,"<=28"))
=IF(COUNTIFS(B3:F3,">=29",B3:F3,"<=42")=0,"",COUNTIFS(B3:F3,">=29",B3:F3,"<=42"))
=IF(COUNTIFS(B3:F3,">=43",B3:F3,"<=56")=0,"",COUNTIFS(B3:F3,">=43",B3:F3,"<=56"))
=IF(COUNTIFS(B3:F3,">=57",B3:F3,"<=69")=0,"",COUNTIFS(B3:F3,">=57",B3:F3,"<=69"))

Each one is returning how many numbers find in a group and them I form a group
The formulas apparently work find for thousand of records but this one and now Id have to check how many could be wrong

 

[vladi305]

If I remove the IF condition then it works fine: =COUNTIFS(B3:F3,">=43",B3:F3,"<=56")

 

[RoryA]

Are you saying that without the IF it returns a non zero value? The 56 appears to be left aligned so is probably text.

 

[vladi305]

Are you saying that without the IF it returns a non zero value? The 56 appears to be left aligned so is probably text.

All format were fine so I went back to the data source and copy and paste the value from another cell and it looks like the datatype on the data source was different and I checked everything and the rest of the data is looking good. Thank you!