Good morning,

I have the below formula which appears to work fine in 2007 but not with
earlier versions of excel.

Could someone please advise?

=SUMPRODUCT((JAN!G:G=B18)*(JAN!M:M="y")*(JAN!B:B=C 2))

When I save the document excel normally warns that certain formulas won't
work, however, it seems to think the above is OK, but thinks
=COUNTIFS(JAN!G:G,B14,JAN!B:B,C2) isn't,,, yet this one works fine in other
versions.

Thanks in anticipation,

Kind regards

Aaron