Find Text String or Key Word Between Date Ranges & Sum Values

Hi,

I have a 3 colums in which the first has a bunch of dates, the second has hourly charge codes & the third has a numerical value. I'm seeking a function that will find between date ranges - The work week, find the text string or key word & then sum up the values.

For example:

Column H - 02/11/13 through 02/17/13

Column I - Find the word "Leave" which has other text or words around it

Column K - Value 4

I'm using the following function works well to find the word "Leave" through column I & numberical value but now I'm looking to add the date range:



=SUMIF(J:J,"*Leave*",K:K)


How do I modify?

Thanks