Hello,

I have been trying for days to get the following function to work:

=SUMPRODUCT((JAN!G:G=C18)*(JAN!M:M="y"))=COUNTIF(J AN!B:B,C2)


The Sumproduct section works fine in isolation... but the above gives me a
true/false result.

I have tried * instead of = prior to the countif, but this results in an
incorrect outcome.

Please help,

Thanks

Aaron