Sumif based on name, start and end date

By this example you can pull the data in excel based on name, start and end date

 

 

=SUMIFS($C$2:$C$32,$B$2:$B$32,I4,$A$2:$A$32,">="& $G$2,$A$2:$A$32,"<=" & $H$2)

 

to download the example click on the below link 

 

http://s000.tinyupload.com/?file_id=24613670605322543211