Date Range data retrieval

[Shan9]

Hello all,

Wondering if anyone can help me with my query; I've a spreadsheet Sheet 1 contains

Date From To 01/01/2018 07/01/2018 Name Time Name 1 07:00:00 Name 2 Name 3 Name 4 Name 5 <colgroup><col><col><col></colgroup><tbody> </tbody>
and Sheet 2 contains Name 01/01/2018 02/01/2018 03/01/2018 04/01/2018 05/01/2018 06/01/2018 07/01/2018 08/01/2018 09/01/2018 Name 1 01:00:00 01:00:00 01:00:00 01:00:00 01:00:00 01:00:00 01:00:00 Name 2 Name 3 Name 4 Name 5 <colgroup><col><col span="5"><col><col span="3"></colgroup><tbody> </tbody> <strike></strike> my question is in Sheet 1 based up on the date range either 01/01/2018 -07/01/2018 or any range how can I retrieve total time from Sheet 2 to Sheet 1 for the corresponding Name 1 or 2 etc.. in the example above over a date range 01/01/2018 -07/01/2018​ Name 1's total time is 07:00:00 Any help would be much appreciated. Thanks in advance. I've used Sumifs, Hlookup, sumproduct but no success.

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[Tetra201]

Try

=SUMPRODUCT(('Sheet 2'!$A$2:$A$6=$A6)*('Sheet 2'!$B$1:$J$1>=$A$2)*('Sheet 2'!$B$1:$J$1<=$B$2),'Sheet 2'!$B$2:$J$6)

 

[Shan9]

Thanks a lot "Tetra201" it worked.

 

[Tetra201]

Glad to have helped.