SUMIFS proper format for multiple criteria

I've attached a workbook which gives an example of some data I need to sum according to the timestamp of the hour.

Since Excel's time format divides a 24 hour day into fractions I've included a column (AC) showing the hours of the day in 24 hour increments (as fractions).

The incorrect formulation of the SUMIFS formula (below) is returning a VALUE error. Can you tell me what I'm doing wrong?

Please Login or Register  to view this content.

I want to sum the numbers in column N which fall between the timestamp of 0 and .01467 (which should correspond to the hours of 0:00 and 1:00).
Thanks !

How about

Formula:

Please Login or Register  to view this content.

Although I disagree with your expect result

Fluff,

Thanks, you nailed it. And my expected result was indeed wrong too. I had just visually summed up the first day (of many)!

Thanks MrShorty. The problem was that I was considering the wrong column as the "criteria." The correct criteria range is in column V.

You're welcome & thanks for the feedback