| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting unique records with additional criteria
I have a list of unique records in a spreadsheet. Each record has a
value of either "open" or "closed". I can get the total number of unique records by doing a = SUBTOTAL(3,A2:A999), however I need a similar formula that can count the number of unique records + count the number of records either with an "open" or "closed" status (all in one entry). Ex - = SUBTOTAL(3,A2:A999, ="OPEN") Any ideas? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
| Counting Unique Values Given Criteria | Excel Worksheet Functions | |||
| filtering for unique records | Excel Discussion (Misc queries) | |||
| Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
Threaded Mode
