Hi! I am trying to do a COUNTIF type formula but I cannot find anything to work. Not sure why I cannot upload images or links to this post.
Basically, I have a lookup column that looks up info from another table and shows an array with emojis (checkmark, x, triangle); so, for example, the first cell shows , , , , , . I want the second column to count how many green checkmarks are in the first column; that is, I want it to show the number 5. Any ideas?