I've seen several discussions regarding a formula to count number of times the letter "x" appears in a "column". What if I have varying number of "X's" in a "cell", i.e. "XX" in C1, "XXX" in C2, "X" in C3, and "XXXXXX" in C4 - I want to have a total of that column that would indicate 9 "X's" in that column. Is there a formula/function for that?
XX
XXX
X
XXXXXX
=====
12
Bookmarks