Summing Rows with Multiple Criteria

Which function do I use to count all of the rows that have both the
numberical value >0 in column B AND the words "Star quality" in Column C?



A
B
C

Company
Widgets
Quality

Best Buy
5
Good

Computer City
0
Star Quality

WalMart
2
Star Quality

Sam's
1
Star Quality

Office Depot
3
Poor

Total Count

2

Check your other thread:

http://www.excelforum.com/showthread.php?t=493597

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(A4>0,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(A4>0,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.