Hello everyone...

I got this formula as a request for help...

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


Now when I can calculate number of printers sold.. I have also T
column.. in which I have information about the earned money on each
printer... so..
Now I need to calculate the money earned, information is in T column,
using the previous formula that calculates pieces sold between two
dates.. (F1 and F2).. I hope you get it.. Thanks for participating


--
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