SUMIFS Struggles using Named Ranges for Text, Numeric, and Date Content

I keep getting the return of the following statement to be '0'. It should be a value greater than Zero. I am thinking it's the time formatting of the Named ranges, but I tried matching formats without success. Any help would be greatly appreciated!!

=SUMIFS(Sales,OrderDate,$A7,SalesChannel,$F$1)

Sales (Named Range Sheet2!$A:$A): 10.87
Order Date (Named Range Sheet2!$B:$B): 10/9/2016 5:36:14 PM
SalesChannel (Named Range Sheet2!$C:$C): VendorName (text field)
$A7: 10/9/2016
$F$1: VendorName (text field)

My Workbook using your data works fine. See my attachment.
Remember that the information in A7 and F1 must be on the same sheet as the SUMIFS() formula, as you don't include a sheet reference.
Also the date in A7 needs to match exactly with the dates found in B:B, which yours doesn't. Remember that dates are actually stored as numbers, and in Col B you have 42623.73 and in A7 42623 which won't match.

Thank you for your reply, you are correct that it works when the dates are identical.

My issue is when the Times are off by an hour or more. In the spreadsheet you provided 9/10/2016 5:36:14 PM matched with OrderDate: 9/10/2016 5:36:14 PM

In my case I am trying to find the match with OrderDate: 9/10/2016 6:36:14 PM

kross said:

TIn my case I am trying to find the match with OrderDate: 9/10/2016 6:36:14 PM

Click to expand...

You should attach example of your workbook?
Look at the solution in my example.
Is that what you are looking for?

If the solution offered by Navic doesn't suit you, then as he has said, can you post some sample data that illustrates your expected results, in addition to showing how the data is organised in your workbook.