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

## Bookmarks