Does the target range have spaces at the front or end?

--
HTH

Bob Phillips

"MESTRELLA29" wrote in message
...
=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