A
Aaron Hodson \(Coversure\)
Hello,
I have been trying for days to get the following function to work:
=SUMPRODUCT((JAN!G:G=C18)*(JAN!M:M="y"))=COUNTIF(JAN!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
I have been trying for days to get the following function to work:
=SUMPRODUCT((JAN!G:G=C18)*(JAN!M:M="y"))=COUNTIF(JAN!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