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. |
#2
|
|||
|
|||
Hi!
Try one of these: =SUM((A1="yes"),(C1="yes"),(E1="yes"),(F1="yes")) =SUMPRODUCT(--(MOD(COLUMN(A1:F1),2)=1),--(A1:F1="yes"))+(F1="yes") Biff "VB" wrote in message ... 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. |
Reply |
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 |