sumifs with date & time criteria

[mamachrissy1028]

I have been tinkering with this formula for quite some time and have not been able to figure out why it is returning a value of zero. I am referencing cells that are dates and times, and have double and triple checked to make sure they are in the same format. I have tried various modifications of this formula to try to get it to calculate but nothing i do seems to make a difference. Any and all feedback would be great. Please keep in mind that the data listed is acquired from an outside source so cannot be changed. My formula will need to be adjusted to resolve. I have attached a sample spreadsheet to recreate my problem. Thank you!

[daddylonglegs]

Column D actually contains the time and the date - it doesn't matter that only the time is shown, the formula is reading the date too, so you can add the date in to the criteria, try this version

=SUMIFS(E:E,$C:$C,M4,$D:$D,N4+M4)

[mamachrissy1028]

i noticed that but apparently i tried to make it too complicated by using the concatenate formula as opposed to simply adding.... urg. Thanks for the help!