must be the same size
=sumproduct((rnga=1)*(rngaB="joe")*rngC)

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"sabunabu" <sabunabu.1zxl3n_1134397500.9269@excelforum-nospam.com> wrote in
message news:sabunabu.1zxl3n_1134397500.9269@excelforum-nospam.com...
>
> How would I use Sumproduct? I thought the dimensions had to be the same
> and "large core" wouldn't be the same as 10% right? What would I fit in
> each array?
>
> I would like to make it an ongoing formula that recalculates
> automatically as the data changes so the autofilter option wouldn't
> really work.
>
>
> Thanks in advance!
>
>
> --
> sabunabu
> ------------------------------------------------------------------------
> sabunabu's Profile:
> http://www.excelforum.com/member.php...o&userid=29395
> View this thread: http://www.excelforum.com/showthread...hreadid=492694
>