SumIfs or Maybe SumProduct

Hi Everyone,
I'm having trouble with what I think is a SumIfs problem - at least that is what I've tried so far.
What I would like to do is: I have a report broken down by people/projects/dates - and I'd like to neatly sum up the total hours each person spent in a day.
For instance how many hours did Aaron work on all projects on July 14th...
I have the work on the tab Report and I'm trying to sum on Sheet1 (if it is easier to sum on the same page as report fine, but I'd prefer it on the second tab).
I tried =SumIfs(Report!E:E (total hours), Report!D:D (date), Sheet1!B2 (date row)(Report!C:C(user name), Sheet1!A3 (user name))

Could anyone help, please...

It's the gaps in your data on Report sheet.

So you have the formula
=SUMIFS(Report!E:E,Report!D:D,Sheet1!B2,Report!C:C,Sheet1!A3)

0 IS the correct answer.
There are 0 rows where Column C = A3 (Aaron) AND Column D is B2 (Jul 14, 2017)
In fact, on the Report sheet, every single name in column C, the corresponding cell in D is blank.

You need to fill in the blank cells in both C and D.

You need to clean up your data in the Report sheet first. The User names need to appear on every row that they apply to. Also, you seem to have some hours duplicated, but with no name nor date.

Then the formula in B3 of the summary sheet would become:

=SUMIFS(Report!$E:$E,Report!$D:$D,B$2,Report!$C:$C,$A3)

which can be copied across and down as required.

Hope this helps.

Pete

Awesome! It worked and THANK YOU!!