col a col b answer
3sha000011 0124 3sha & 0 =1
3sha000012 2336 3sha & 2 =1
4sha000013 0495 4sha & 0 =2
4sha000002 0113


if col a begins with 3sha and col b begins with 0 count
answer 1

if col a begins with 4sha and col b begins with 0 count
answer 2

I tried countif(and(left(a2:a5,4)="3sha",b2:b5,1)="0")) and couldn't get it to work.

i have 8000+ in col a and 8000+ in col b