Hi

Col A has a list of dates UK Format dd/mm/yyyy

Col C has a unique local codein each cell which is always in the following format 1 xxx yyy (one number and 2 sets of three letters)

I would like a formula that will return how many times the number one occurs in any given month, The attached picture use Feb as an example.

I also want a formula that will return a count of abc and a separate count of yyy.

Hope the picture is obvious

screen.jpg