Thursday 12 November 2015

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 
 
 
 
 



No comments:

Post a Comment