Can the "count if" function save me?
Posted by Dan on December 10, 2001 8:00 PM
Okay, my beginnermediate Excel knowledge is not helping me here. I've got a column of various numbers. Each cell contains multiple numbers separated by the || characters. For example:
You get the picture. Anyways, How do I count those individual numbers without having to insert a delimiter and separating out each number into its own column? I tried =COUNTIF(A1:A65536,1)to tally up all the 1's but that did not work. Big surprise.
Thanks in advance.