Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if cell = a value
I'm trying to find a way to count in a given set of data.
N N 0 N 0 Y 0 Y Y 0 N 0 For example, in the above example. I'm try to find a formula that will look at the Y an count the number of zeros. So the answer would be 2. Or if I was doing N it would be 3. When I try todo an array I get 7, it is countying all values not whether it is Y or N or if it even contains a zero. Any help would be great. Thanks Vick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell Count | New Users to Excel |