| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
