A
Aaron Hodson \(Coversure\)
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=C2))
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
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=C2))
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