I was wondering if their is a way to count the number of unicode entries in a column.
1 =UNICHAR(9745)
2 =UNICHAR(9745)
3 =UNICHAR(9745)
Total 3
My current idea =COUNTIF(A4:A33,"=UNICHAR(9745)") returns 0 when it should be 3. Any help would be greatly appreciated, thank you for your time. I think the issue is COUNTIF only counts numbers or TRUE(a entry is 1)/FALSE(a non entry is 0).