sumproduct and countif in one formula

  • Thread starter Aaron Hodson \(Coversure\)
  • Start date
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
 
G

Gary''s Student

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

Aaron Hodson \(Coversure\)

Perfect!!!

Thanks very much for your help and prompt assistance.

Kind regards

Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top