Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT with 3 criteria
I am not sure why the result always showing zero.
Column A contains name: A, B, C, A, C, ..etc Column B contains range of date: MM/DD/YYY Column C contains # of hours, some number are negatives I am trying to find out the # of hours for name A in a range of date, so I put the following equestion together, but it always return zero. =SUMPRODUCT(--($A$5:$A$417="A"),--($B$5:$B$417=39896),--($B$5:$B$417<=39909),($C$5:$C$417)) I am using MS 2003 thanks, Kit |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add two criteria that should not be met to sumproduct | Excel Worksheet Functions | |||
Sumproduct - two+ criteria | Excel Worksheet Functions | |||
Sumproduct 4 criteria | Excel Worksheet Functions | |||
SUMPRODUCT with 3 criteria | Excel Discussion (Misc queries) | |||
Sumproduct with 2 criteria | Excel Worksheet Functions |