Count entries in a range that has text and number+text entries

Evan I
Evan I ✭✭
edited 08/30/23 in Smartsheet Basics

Im trying to count the number of times street avenue occurs in a column based on the range a user enters. I have tried using countifs >=starting range and less than ending range, but it only counts the number/text entries. Looking below if I did countifs({avenue},>=110, {avenue}<111) I only get 2 as the count, but I should get 5. How do I make this work.

Best Answers