Countifs and Sumifs VBA code with criterias between 2 date range

Hi Sixthsense,

Thanks for your response, but i think you misunderstood my request, sorry if i didnt explain it clear enough. The resuts on range D2:E21 is the correct result that i want to get, but due to my Large actual set of data i'm forced to seek another way to get this results , all i can think is using VBA code that i hope it will run much faster than my current countifs and sumifs formula, when i run my formulas in my actual data it took around 10 minutes to run the countifs only. I try your formula but i see that it didnt refer to the member ID but what i want to get is the count of each member in report sheets that get the data from Data sheet based on the date.

The purpose i need to do this is because the CS department in our company make a call to our customers ( all the customers that has been called is on report sheet ). So we want to see whether the customer purchase anything after 7days the call been made , how many times they purchase and how much is the amount. Please kindly ask me again if there is still anything unclear.

Hi sixthsense,

Actually you can just apply the code to the workbook that i attached and i will try to apply it on my workbook because i also want to learn..just don't know how to start to make the code , Thanks in advance for your help.