Countifs and Sumifs VBA code with criterias between 2 date range

Hi Guys,

I need your help to make a code of how to do countifs and sumifs alike function in VBA that can run much more faster than formula due to i have a very large sets of data. Basically what i want to do is for the code to search the ID ( Member ID ) of customer and then see if the date fall between the range of purchase and 14 days after. I have attached a sample workbook for your better reference. Please kindly ask me if there is anything unclear. Thanks for the time.

Countif and sumifs VBA code based on criterias between date range ( forum Q ).xlsx