| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with counting two different criterias.
Hello, I need help with a counting criteria I have in two different columns.
For example I need to know how many "40"'s from column A are Comp or OUTST or Above and so on from Column B, then how many "83"s are COMP or OUTST or ABOVE and so on. I have used the CountIf function but it will only do the first criteria. A B 43 COMP 83 COMP 83 COMP 40 COMP 43 COMP 40 COMP 40 OUTST 40 ABOVE 40 NEDVL 83 UNSAT |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too many criterias... | Excel Worksheet Functions | |||
| If Criterias | Excel Discussion (Misc queries) | |||
| Sum If using 2 criterias | Excel Discussion (Misc queries) | |||
| Counting instances based on two criterias | Excel Worksheet Functions | |||
| Counting cells if special criterias are true | Excel Worksheet Functions | |||
Threaded Mode
