Hello,

I have been working on 2007 excel and used the below formula:

=COUNTIFS(JAN!G:G,B14,JAN!B:B,C2)

I have just noticed upon saving that this will not work on earlier versions
of excel.

How do I need to change the formula please to make it compatible?

Thanks

Aaron