Hi

The solution posted by daddylonglegs should work fine.
If you are getting a numeric result from
=SUMPRODUCT((Selling!F5:F30000="Laser printers
mono")*(Selling!A5:A30000=--F1)*(Selling!A5:A30000<=--F2)*Selling!H5:L30000)
then adding the additional term to multiply by
Selling!T5:T30000
should turn this into a value, provided the data in T5:T30000 is
numeric.

Maybe you have some text values in column T rather than numbers. You
could try

=SUMPRODUCT((Selling!F5:F30000="Laser printers
mono")*(Selling!A5:A30000=--F1)*(Selling!A5:A30000<=--F2)*Selling!H5:L30000*(--Selling!T5:T30000))

--
Regards

Roger Govier


"alen_re" wrote
in message ...

I still need this one badly :(


--
alen_re
------------------------------------------------------------------------
alen_re's Profile:
http://www.excelforum.com/member.php...o&userid=28331
View this thread:
http://www.excelforum.com/showthread...hreadid=506593