View Single Post
  #3   Report Post  
bj
 
Posts: n/a
Default

is the c3 reference in the first cells in the current page or the GDOS page?
are the B column data actually values or could they be numbers as text.
a quick check is to run each segment separately
=sum(GDOS!$B$3:$B$10000)
=SUMPRODUCT(--(GDOS!$C$3:$C$10000=$C3)) or
=countif(GDOS!$C$3:$C$10000,$C3)

"MESTRELLA29" wrote:

=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