I have eventually worked out how to do a complicated (to me anyway) countif but i'm sure there must be an easier and more economical way to do it.

My work around is:-

=COUNTIF(January!$B$7,Sheet2!$J2)+COUNTIF(January!$B$12,Sheet2!$J2)+COUNTIF(January!$B$17,Sheet2!$J2)+COUNTIF(January!$B$22,Sheet2!$J2)+COUNTIF(January!$B$27,Sheet2!$J2)+COUNTIF(January!$B$34,Sheet2!$J2)+COUNTIF(January!$B$39,Sheet2!$J2)+COUNTIF(January!$B$44,Sheet2!$J2)+COUNTIF(January!$B$51,Sheet2!$J2)+COUNTIF(January!$B$55,Sheet2!$J2)+COUNTIF(January!$B$56,Sheet2!$J2)

As you can see it is a long way around, and then I had to do the same for every other month and other criteria besides J2.

I tried plenty of different ways I found on this and various other sites, all to no avail.

Is there a more efficient way to do this countif???

Thanks in advance.

Craig.