countif probelm

[excelbee]

Hi

I have counif problem in which excel consider the number 5-1 and 5-01 as same, and returns the count as 2,instead of count 1.
Please anyone can solve this?I tried index match also,but no use!!!!
How to sole this?

 

[Andrew Poulsom]

That's interesting. I imagine it's because thay can be interpreted as dates. This worked for me:

=SUMPRODUCT(--(E1:E2="5-1"))