| 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 |
| 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) | |||
Threaded Mode
