Make COUNTIF count the number of elements

I have a table where the options are from a select list where you can select multiple options. I want to count how many of each of the options appears even when selected with other options.
In excel I am able to use " * “& &” * " for the countif partial text, I’m not sure if this is possible in coda where the options are from a select list.

Thanks For the help!

Edit: Also just realized my example counts pineapple into the “Apple” count but that’s besides the point, I don’t have the same issue with my actual data.

:wave: Hey there! Welcome to Coda!

This should do what you are looking for:

Let me know if you need any more help or if its not doing exactly as you want. Look at the formula in the “Count” column to see how its structured