| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to report a count that meets multiple criteria.
Help - my brain is fried! This one will be easy for you guys!
I need to report a count of data in cells that meet multiple criteria from one sheet, and report it on a summary sheet For example: I need to know how many defects are labeled with a certain Severity and Status. Critical/Open, Critical/Closed, Critical/Deferred. Sheet "Defect" A B C 1 Description Severity Status 2 Defect 1 Critical Open 3 Defect 2 Critical Closed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to display data if it meets multiple criteria | Excel Worksheet Functions | |||
| How do I count in column A when it meets all criteria in three col | Excel Worksheet Functions | |||
| Retrieving an Item from a List that Meets Multiple Criteria | Excel Worksheet Functions | |||
| Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) | |||
| how can i count a number that meets a criteria? | Excel Worksheet Functions | |||
Threaded Mode
