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

try sumifs
B1 start date to look
C1 end date to look

=SUMIFS(K:K,J:J,"*Leave*",H:H,">="&B1,H:H,"<="&C1)

Hi vlady,

This function works great!!!

Thanks

your very much welcome.