sumproduct and countif in one formula
 

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

sumproduct and countif in one formula
 

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

sumproduct and countif in one formula
 

Perfect!!!

Thanks very much for your help and prompt assistance.

Kind regards

Aaron

"Gary''s Student" wrote in message
...
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