Perhaps the countif is not needed:
=SUMPRODUCT((JAN!G1:G10=C18)*(JAN!M1:M10="y")*(JAN !B1:B10=C2))
--
Gary''s Student - gsnu2007k


"Aaron Hodson (Coversure)" wrote:

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