Count number of occurrences of names per month

[ellisbobby]

Hello, I have searched all over the google machine and can't seem to wrap my head around something that should be relatively simple. I've have come here in the past and you folks have always helped me out.

I have a series of data that I have exported that has worker's names and the dates they have used a program. I'm trying to have a separate table that analyzes all the dates and counts the number of times that name has come up that month. For instance, Bob used the program 35 times in January, 26 times in Feb, etc.

I'm trying to determine who has used the program the most on a month by month basis. I feel like I've done way more complex stuff than this in the past, but can't seem to get this to work.

Old me would just separate out the data manually and count from there, but I'm going to have to do this every month and it would be easier to just copy and paste the data in each month.

Thank you so much for having this site. Y'all rock!

 

[DanteAmor]

Put the following formula in cell E2 and copy to the right and down.

=SUMPRODUCT(($A$2:$A$1000=$D2)*(TEXT($B$2:$B$1000,"mmm")=LOWER(E$1)))

Or this:

=COUNTIFS($A:$A,$D2,$B:$B,">=01/" & E$1 & "/2023",$B:$B,"<"&EOMONTH("01/" & E$1 & "/2023",0)+1)

 

[ellisbobby]

Excellent! Thank you! I don't think I would have come up with that solution myself. Much appreciated!

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)