| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count designated cells
I want to count designated cells (versus a range) only if they meet a certain
criteria: Count cells A1, C1, E1 and F1 if they contain the word "yes" A1=No Answer B1=Yes C1=Yes D1=Yes E1=No Answer F1=No In the above example the answer would be 1; cells B1 and D1 are not counted because they are not designated in the formula, where they would be counted if a range were used. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count # of cells b/w cells ... | Excel Discussion (Misc queries) | |||
| count cells that have *text1* and don't have *text2* | Excel Discussion (Misc queries) | |||
| Count cells in a column that contain dates | New Users to Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| How do I count shaded cells | Excel Worksheet Functions | |||
Threaded Mode
