sumproduct and countif in one formula

[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

 

[Gary''s Student]

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

 

[Aaron Hodson \(Coversure\)]

Perfect!!!

Thanks very much for your help and prompt assistance.

Kind regards

Aaron