Counting formula question
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
|