Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Formula Help | Excel Discussion (Misc queries) | |||
Sumproduct or Other Formula? | Excel Worksheet Functions | |||
OR in a SUMPRODUCT formula | Excel Worksheet Functions | |||
sumproduct formula | Excel Worksheet Functions | |||
=SUMPRODUCT formula help | Excel Worksheet Functions |