SUMIF Formula to Include Data Range and SUM of Hours

[BillScott]

Hello,

I have three columns, Column A is a date range (short date), Column B contains Names, Column C contains Hours. I would like to pull a person's hours by their name and specific date range (from to). Right now I have the following formula to pull just the sum of the hours based on the person's name, but I'm not certain how to include a specific date range: =SUMIF(B1:B50, "Harry", C1:C50). I would like to pull all of Harry's hours for a specific month of the year only and not the entire year. I can do this by manipulating the B1:B50 & C1:C50, but I believe there is a more robust formula that can solve this dilemma.

 

[johnny51981]

Try
=SUMIFS($C$1:$C$50,$B$1:$B$50,"Harry",$A$1:$A$50,">="&[the cell with the Start Date or the Start Date],$A$1:$A$50,"<="&[the cell with the Finish Date Date or the Finish Date])

 

[BillScott]

Try
=SUMIFS($C$1:$C$50,$B$1:$B$50,"Harry",$A$1:$A$50,">="&[the cell with the Start Date or the Start Date],$A$1:$A$50,"<="&[the cell with the Finish Date Date or the Finish Date])

This is what I was thinking, but is there another way to capture the date range by inputting something like 'May' instead of selecting a range?