Prev: Unique Random List
Next: Copy value according to date
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 List
Next: Copy value according to date