sumproduct formula help

[Guest]

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

 

[Bob Phillips]

Maybe it should be <=B3

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)