How to search data between date range

Dear all,

I have data in which Date wise,Customer wise,Product wise sale is mentioned,As I have five years data I want excel should show the data between the date range I selected,Here If I select only date so excel should show all the sale between that range.

And if I select Date & customer so excel should show sale for that particular customer,And If I select Date,Customer name,and Item code, So it should show that particular item sale for the particular customer between that range.

Kindly help me in this regards,

Thanks

Dev.

Dear JohnTopley,

Thank you so much, Formula given by you is working great. It will help me a lot.

Thanks
Dev.

Dear JohnTopley ,

Formula given by you is working great,I want to add another 1 conditions in that,If Customer & Item code is not selected(Field are blank) it should show all customers & item sales for the date range given.

Attached sample file for reference....

Kindly help in this regards,

Thanks in advance

Dev.

Dear JohnTopley,

Excellent,Brilliant, Have no words to describe,You are simply genius.
Now It work as I want,

Thanks and regards,

Dev

Dear JohnTopley,

Sir facing one problem here, I have selected one customer(ABDULHUSAIN ABDULALLY HAKIM) for this customer we sold 150kg 25-01001(item) between 1st May 2017 to 31st May 2017, it is giving total sold qty correctly but in the invoice wise details it doesn't show one invoice.

the same problem is coming for each customer.(one invoice is missing in details)

attached sample sheet for reference.

Dev.

My typo error ..

in B7

=IFERROR(INDEX(Sale12TO17!$G$2:$G$2000,SMALL(IF(IF($D$3<>"",(Sale12TO17!$F$2:$F$2000=$D$3),1)*(Sale12TO17!$G$2:$G$2000>=$C$3)*(Sale12TO17!$G$2:$G$2000<=$C$5)*(IF($E$3<>"",Sale12TO17!$I$2:$I$2000=$E$3,1)),ROW(Sale12TO17!$F$2:$F$2000)-ROW($G$2)+1,""),ROWS($G$2:$G2))),"")

Change in All formulae

Dear JohnTopley,

Thanks you much sir,

Regards,

Dev.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.