sumproduct formula help
 

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

sumproduct formula help
 

Maybe it should be <=B3

--
HTH

Bob

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

"dr350x" wrote in message
...
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