lookup/match against multiple criteria and get the sum of multiple entries

Good Afternoon Everyone -

I am not 100% sure on how to complete my results I am looking and am looking for advice or ideas on how to achieve my results.

I have included a sample file to assist in describing what I am trying to achieve.

My actual workbook is a time sheet that I have put together with some great advice and assistance from you guys. The 'DataSource' is imported data via pilot table which I have broken down using the 'Name Manger' option in excel.

I would like to be able to search/match by any specific user (B4) and date (C4) entered in worksheet 'Summary' which would pull the information from worksheet 'DataSource'. I need it to give me a result of the total qty (D4) from all the multiple entries made by that user and date entered in worksheet 'Summary'. I also need to be able to break down the totals by specific 'Activity' or a combination of activities (E4) as shown in worksheet 'Summary'.

I have did some searching on this forum and I believe this can be achieved by using the SUMIF function, but I am not 100% sure.

Any advice or assistance would be extremely grateful.

for your first, total you can use this:

=SUMIFS(DataSource!F:F,DataSource!B:B,B4,DataSource!A:A,C4)

for the second, only count A and B, you can use this

=SUMIFS(DataSource!F:F,DataSource!A:A,Summary!C4,DataSource!B:B,Summary!B4,DataSource!C:C,"A")+SUMIFS(DataSource!F:F,DataSource!A:A,Summary!C4,DataSource!B:B,Summary!B4,DataSource!C:C,"B")