Hi

SUMPRODUCT doesn't work with entire rows or columns - you must have all
ranges to be determined, or even better - use dynamic named ranges. NB! in
SUMPRODUCT, all ranges MUST be of same dimension.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Kstalker" wrote in
message ...

I have a problem surrounding sumproduct and setting criteria.

I need to sumproduct based on row criteria '19:19'. The value for the
row criteria is set in an other cell 'E23'.

So sum of row 9 and row 17 where 19 is equal to E23.


=SUMPRODUCT((OFFSET(A9,,MATCH(E23,19:19,0)-1,(OFFSET(A17,,MATCH(E23,19:19,0)+1)/1))))


Any help greatly appreciated


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile:
http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=466133