Countif If with 2 Criteria but with Left function in one!!

Morning all,

Well i have a new and wonderful problem today.

I need to count 2 criteria but on the second criteria i only need to know if the first 2 numbers match the number 10.

here's what i've got so far:

Please Login or Register  to view this content.

i assume i need the left function in there somewhere? and i have tried it but i'm really struggling!! please help!!

thanks for reading my thread folks!!

Through trial and error i managed it:

Please Login or Register  to view this content.

This actually counts 3 different criteria and works a treat!!

woo hoo!!

Thanks to those who took the time to read my thread!!