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

--
Don Guillett
SalesAid Software

"sabunabu" wrote in
message ...

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