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:

=SUMPRODUCT((INDIRECT("'"&$B$5&"'!H1:H10000")=$B$4)*((INDIRECT("'"&$B$5&"'!$L$1:$L$10000")=G4)))

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:

=SUMPRODUCT(((INDIRECT("'"&$B$5&"'!H1:H10000")=$B$4)*((INDIRECT("'"&$B$5&"'!$L$1:$L$10000")=$K$3)*((LEFT(INDIRECT("'"&$B$5&"'!$G$1:$G$10000"),2)=""&K5)))))

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

woo hoo!!

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