Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF() with multiple criteria
I am looking to pull some data about a section of one of my worksheets.
Specificly I have 3 columns that I want a count of the number of instances of each unique combination in those 3 cells (IE the number of times "1, 0, 0" appears, "1, 1, 0" appears, "1, 1, 1" appears, etc etc). The second part of this would be If it was possible to semi automate this so that I don't have to write a function for each unique series. Thank you very much for any and all help you can offer me. AlexV |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use multiple criteria with COUNTIF: between dates and not blank | Excel Worksheet Functions | |||
Counting cells using multiple criteria | Excel Worksheet Functions | |||
Multiple Criteria using countif | Excel Worksheet Functions | |||
multiple criteria in one field 4a,4b etc of countif? | Excel Discussion (Misc queries) | |||
Multiple CountIf Criteria | Excel Worksheet Functions |