Here's another way...

=COUNTIF(E2:E20,"Not chosen from list")

Hope this helps!

In article ,
frieam05 wrote:

I am attempting to count the number of times a phrase occurs in a column, but
this column has reasons in a phrase dropdown list form (generated from a
hidden column on the same worksheet). Is there something I'm missing in this
formula?
(the
{=SUM(IF((E2:E20="Not chosen from list")*1,0))}

A B C D
E
sent back corrected Ref # Reason: (hidden
with list
1 123 Blank fields or dashes of
text choices in
1 124 Not chosen from list
dropdown in D)
1 125 Not chosen from list

Totals: Not chosen from list ____
Blank fields or dashes ____
(etc.)

Thanks for any help