Sumifs between two dates in another sheet

[sin2190]

So basically I'm trying to add the amount of phones sold each week for each employee for their commission breakdown.
So I have Commission Breakdown as the First Tab and Sheet1 (which is exported directly from the POS) which is the phones sold

So in CB Tab I have a From date (A6) and a To date (B6) of each week in the month already because I assumed I needed it for this to work.
And in Sheet1 (Phones Sold) I have the quantity of phones sold in E and Date of the sale in B.

Not sure if its important to mention but the POS doesn't just export the date but the exact time if was sold as well. Not sure if that an issue.
So instead of
[TABLE="width: 103"]
<colgroup><col width="103"></colgroup><tbody>[TR]
[TD="class: xl68, width: 103"]2/1/2017
it puts
[TABLE="width: 103"]
<colgroup><col width="103"></colgroup><tbody>[TR]
[TD="class: xl68, width: 103"]02/01/2017
10:46
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I have been experimenting for that last hour or so and couldn't seem to get it to work kept giving me #VALUE error.

I can upload a sheet for a better picture if it helps.

Thank you.

 

[FDibbins]

You could probably do it with something like this...

=sumifs(sum-range, date-range, ">=start-date", date-range, "<= end-date")

You can either hard-code the dates...
=sumifs(sum-range, date-range, ">=2/1/2017", date-range, "<= 3/6/2017")
Or you could put the dates in their own cells and reference them (note the difference in syntax)
=sumifs(sum-range, date-range, ">="&$A$1, date-range, "<="&$B$1)

 

[sin2190]

Thanks that definitely allowed to progress and figure it out better but for some reason its showing as 0.
This is what I'm using now.

=SUMIFS(Sheet1!E2:E250,Sheet1!B2:B250,">=Employee!E6",Sheet1!B2:B250,"<=Employee!B6")

I checked the format of the date and of the quantity seems fine....

 

[sin2190]

I got it!!!!! Thank you

 

[FDibbins]

OK great, did you remove the "" from the reference, like I showed in my 2nd example?
=SUMIFS(Sheet1!E2:E250,Sheet1!B2:B250,">="&Employee!E6,Sheet1!B2:B250,"<="&Employee!B6)

 

[sin2190]

I did ,well you see I was having an issue with the SUMIFS function not reading the date properly. It wasn't reading the values of the date (with is function based) but I took a look at yours again and realized I have to use the &$A$ thing. But this is my function now.

=SUMIFS(Sheet1!G2:G250,Sheet1!A2:A250,">="&$A$6,Sheet1!A2:A250,"<="&$B$6)

 

[FDibbins]

Looks good, thanks for the feedback