=SUMPRODUCT(--(GDOS!$C$3:$C$10000=$C3),GDOS!$B$3:$B$10000)

This formula is trying to work as a VLOOKUP for text "1C"

Right now the result of this formula is 0, does anyone know why and how can
I correct this?

Thanks