From: mahlandj on 1 Mar 2010 18:27 I need to find how many times Dan occurs in a certain month. Example Below. A B 1 1/2/10 Dan 2 1/5/10 Dan 3 1/10/10 Perry 4 2/3/10 Perry 5 2/7/10 Dan 6 2/12/10 Perry Answer = 2 for January & 1 for February -- Thanks! From: Teethless mama on 1 Mar 2010 19:02 PIVOT table is the right tool for this. "mahlandj" wrote: > I need to find how many times Dan occurs in a certain month. Example Below. > > A B > 1 1/2/10 Dan > 2 1/5/10 Dan > 3 1/10/10 Perry > 4 2/3/10 Perry > 5 2/7/10 Dan > 6 2/12/10 Perry > > Answer = 2 for January & 1 for February > > -- > Thanks! From: mahlandj on 2 Mar 2010 18:09 Thanks for your help. I was looking for a different way to show the info than the PIVOT table. Maybe I wasn't doing it correctly but I used this formula instead and it worked great. =SUMPRODUCT((MONTH(A1:A6)=1)*(B1:B6="Dan")) - This was for Jan results. I just changed the 1 to a 2 for Feb and then to 3 for March....4......5......6 -- Thanks! "Teethless mama" wrote: > PIVOT table is the right tool for this. > > > "mahlandj" wrote: > > > I need to find how many times Dan occurs in a certain month. Example Below. > > > > A B > > 1 1/2/10 Dan > > 2 1/5/10 Dan > > 3 1/10/10 Perry > > 4 2/3/10 Perry > > 5 2/7/10 Dan > > 6 2/12/10 Perry > > > > Answer = 2 for January & 1 for February > > > > -- > > Thanks!  |  Pages: 1 Prev: Unique Random ListNext: Copy value according to date