hi,
i have the folllowing formula. it calculates properly with the exception of
the last data point.

=sumproduct(--($a$2:$a$1000=$b2),--($a$2:$a$1000<$b3)

data is for items per hour. my times military are 00:00 to 23:00.
i get data returns for 00:00 to 22:00 all calculate appropriatly but 23:00
returns 0. there are data points to be counted in the 23:00 slot. I have
tried different variariations of the formula to no avail.
thanks in advance for your help.

dr350x