One way:

=SUMPRODUCT(--(A1:A1000="DD"),--(B1:B1000="RD11"))

In article ,
Alex68 wrote:

Can anyone show me how to count the number of rows containing two or more
criteria? For example, if one column has the text "DO" and another column has
the text "RD11" how do I count only those rows that contain both DO and RD11?