Sumproduct conditional with dates
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?
|