Hi,

I have this formula:

=SUMPRODUCT((Sheet1!$D$5:$D$96=Sheet3!E10)*(Sheet1 !$F$5:$F$96=Sheet2!$D$21)*(Sheet1!$H$5:$H$96))

but when I make the range larger:

=SUMPRODUCT((Sheet1!$D$5:$D$800=Sheet3!E10)*(Sheet 1!$F$5:$F$800=Sheet2!$D$21)*(Sheet1!$H$5:$H$800))

it doesn't work anymore... Any idea ? Is SUMPRODUCT limited in the
number of raws ?

Thanks a lot in advance.


--
pie_terro
------------------------------------------------------------------------
pie_terro's Profile: http://www.excelforum.com/member.php...o&userid=35790
View this thread: http://www.excelforum.com/showthread...hreadid=555576