D

#### dcb1

AF I have a drop down list. A person can choose the number 1, 2, or

3, or choose the following letters: V, H, F, T, S, CC, BR, A or leave

the cell blank. Therefore, a person can select only one of those 12

choices for each cell in that row. Therefore, I want to count each

cell that contains either a 1, 2 , 3, V, H or CC. If there were 12

cells in that row, and each cell in order contained the following: 2,

V, S, F, S, 1, 3, Blank, T, H, F, Blank. My count would then be 5

because I only wanted to count the 2, V, 1, 3, H. Please give me a

couple of solutions using the functions Count, CountIF and Sum. Thanks!