Formula Help

M

mahlandj

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
 
M

mahlandj

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top