FYI, I tried this =SUMPRODUCT(--(MONTH(C2:C9)=1),--(A1:A10="Carl"),D2:D15)
and I get a value error.

"Carl" wrote:

Name Project Date Hours
Carl Project2 1/2/2006 8
Carl Project2 1/3/2006 8
Carl Project2 1/4/2006 8
Jim Project2 2/2/2006 8
Jim Project2 1/2/2006 -8
Carl Project1 2/2/2006 8

Given the above, I am trying to get a cell to sum the hours for a given
person in a particular month. This is driving me crazy! This is a large
table of data.

The rsult I would like to see

Name Jan Feb Mar ETC
Carl 24 8 16 ETC
Jim 8 16 24 ETC

Can someone help me with this?