View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carl Carl is offline
external usenet poster
 
Posts: 361
Default 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?