Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
Summing with multiple criteria | Excel Worksheet Functions | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |