View Single Post
  #1   Report Post  
LoopKid
 
Posts: n/a
Default SUMPRODUCT using months

I have a worksheet with column N as "JoinDate," with dates listed as days of
the year, and column M as "MemberType:"

Column M Column N
MemberType JoinDate
Individual 2/14/2003
Individual 3/25/2003
Business 1/27/2003
Corporate 7/2/2003

I need help finding a formula to determine how many of each member type
joined during each month. I think it might be a SUMPRODUCT formula, but I
don't know how to specify an argument to find all dates between to other
dates (all days greater than or equal to Feb. 1 and less than or equal to
Feb. 28). Can anybody help me with this??