Thank you for responding. I tried that formula, but the result returned a "0".

Ok, this is the formula I used in order to count all the numbers (words) in the single cell, eliminating spaces. Is there a way to manipulate this formula so that it does the exact same thing, except counting the duplicates only once? The numbers will only be 1-32.

=IF(LEN(TRIM(Jan!G2))=0,0,LEN(TRIM(Jan!G2))-LEN(SUBSTITUTE(Jan!G2," ",""))+1)