More than one value in MID formule

Originally Posted by martindwilson

=sumproduct(--(mid(b9,{3;8},4)="a00b"))*b68

Thanks Martin, this work but I have no idea how the formule works, could you please explain so I can advance with my other codes?