| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I count pairs of cells when each matches a condition?
I want to count the number of instances where 2 separate conditions are each
met e.g. the number of times when column A has a value of "x" AND column B simultaneously has a value of "y" (actually one would be a numerical value and one text). I am getting confused looking at the help section for array formulae. Help?! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count colored cells? | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
