Countifs function

I need to be able to count cells that end in specific digits. I have a lot of data that looks like, P1-1507,P3-602 etc. That are hotel room numbers. What I need is to count all the rooms that end in a 1,4, or 7 and to count the rooms that end in 2, 3,5,6,8,9. Maybe I'm not using countifs right, or that's not what I need, but it doesn't count the cells correctly.

Hello and welcome to the forum.

Try something like this:
=SUM(COUNTIFS(A2:A100,{"*1","*4","*7"}))

Originally Posted by 63falcondude

Hello and welcome to the forum.

Try something like this:
=SUM(COUNTIFS(A2:A100,{"*1","*4","*7"}))

You are a life saver! Thanks man

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.