How to sort list to COUNTIF criteria?

[Audiology]

I have a list of 562 records. In order to generate a targeted mailing list, I would like to display) only those records meeting the criteria:

=SUMPRODUCT(--(M2:M562>0),--(U2:U562>0)) .

How do I do this?

Thanks for the counsel.

 

[Dryver14]

you will probably be better off using filters to get to the options you want.

SumProduct will not achieve what you want it to.

 

[danzon]

Helper column with an if formula to identify those that meet criteria... then filter on that column

=IF(AND(M2>0,U2>0),"X","")

 

[Audiology]

How do I set the filters for a joint/or criterion?

 

[Audiology]

ADVERTISEMENT

Danzon,

Thanks. our posts crossed in the mail. Helper column....too logical.

 

[jamtay317]

=iferror(INDEX(M$2:M$562,SMALL(IF($M$2:$M$562>0,IF($u$2:$u$562>0,ROW($M$2:$M$562)-ROW($M$2)+1)),ROWS(Q$2:Q2))),"")
have to enter with Ctrl+Sift + Enter

 

[Audiology]

ADVERTISEMENT

Jam...

Where do I insert that formula?

 

[jamtay317]

check out this videoExcel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter - YouTube

but I have it in Q2:Q562

 

[Audiology]

Jam..

Thanks,

I got the idea.

 

[jamtay317]

glad to help