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