VBA sum on multi search criteria - how?

I have spent many hours trying to find out how to do the following, but without success, many web searches gave me hope but still no joy, hence my call for help on this forum.

In VBA, I wish to be able to sum any column of data providing the rows are within my selective time period.

I have:-

Sheet – Target with a range A1:R10000
Col “C” holds the timestamp for each row

Sheet – Table with range A1:C35
Col “A” holds start of period timestamp
Col “B” holds the end of period time stamp
Col “C” holds my reference for each 15min time period

So basically I wish to say:-

In Target SUM range (column) “D:D” only if the timestamp in Col “C” is within the time period selected in the Table.

In my past days of FoxPro the BETWEEN function was the preferred option, hopefully the solution is nearly as simple.