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

Summing Rows with Multiple Criteria
 

Check your other thread:

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


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

Summing Rows with Multiple Criteria
 

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