Hi
I reckon SUMPRODUCT is what you need. Something like
=SUMPRODUCT(--(A2:A1000="DO")*--(B2:B1000="RD11"))
--
Andy.
"Alex68" wrote in message
...
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?
|