Hi team,

I need a little help with a forumula...

Basically I'm trying to find the number of occurences a specific string of text there is in a specific Range....the problem is that the string I'm looking for is not the only string in those ranges ... I'm looking for the "9777" String but in a range you would read "9777 installation booked for X date"

I'm using this formula that's givint me zeros

=COUNTIF(M14:M31;LEFT("9777";4))

Thanks for the help!

Cheers,