You cannot use sumif like that, it needs same sized ranges


=SUMPRODUCT((A1:A100=3)*(B1:Z100))

--
Regards,

Peo Sjoblom


"choice" wrote in message
...
how can i get this work?

=sumif(a1:a100,3,b1:z100)

thanks in advance