The formula looks fine to me. A couple things you might check. Are you sure
you're using the correct serial numbers for the dates you want to check in
column B? 39896 = March 24, 2009 and 39909 = April 6, 2009. Next, are your
numbers in column C entered as Text? Adding a -- to your final criteria will
take care of that. --($C$5:$C$417)

HTH
Elkar

"Kit" wrote:

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