You need to use an "AND" or "IF" statement in column "D" because you
want 2 different conditions.
If you use the "AND" statement you just get a "TRUE" or "FALSE" - then
do a "COUNTIF" for "TRUE"
=AND(A40,B4="star quality")

If you use an "IF" -"AND" statement then for the "TRUE" and "FALSE"
part you can enter any text you want.
=IF(AND(A40,B4="star quality"),"star quality","check")
Then accomplish a "COUNTIF" for "star quality"

If you use the IF/AND statement you will get an "ERROR MESSAGE" pop-up
when you close the "AND" box. Just ignore it and put your cursor or the
"IF" part of the statement in the "Formula bar" and click the equal sign
and fill in the values you want for the "TRUE" and "FALSE" part of the
IF statement.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=493605