sum if

[choice]

how can i get this work?

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

thanks in advance

[duane]

try this

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

[Peo Sjoblom]

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


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

--
Regards,

Peo Sjoblom


"choice" <choice@discussions.microsoft.com> wrote in message
news:DB37E636-C276-4A5F-9E3A-0DC8F6D2CD95@microsoft.com...
> how can i get this work?
>
> =sumif(a1:a100,3,b1:z100)
>
> thanks in advance