VLOOKUP to search text between dates

I basically want to search certain text between certain dates and once the text is found, want to add all values of corresponding cells.

Attached sheet has all the info on.

This forum is luckily the place to ask these questions.


Thanks for all the help NBVC....