# Make COUNTIF count the number of elements **URL:** \ **Category:** Ask the Community\ **Created:** [August 17, 2021, 4:06pm UTC](https://connect.superhuman.com/t/make-countif-count-the-number-of-elements/25079 "2021-08-17T16:06:14Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Lin\_Silver](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/lin_silver/32/22236_2.png) [@Lin\_Silver](https://connect.superhuman.com/u/Lin_Silver)\ **Post date:** [August 17, 2021, 4:06pm UTC](https://connect.superhuman.com/t/make-countif-count-the-number-of-elements/25079/1 "2021-08-17T16:06:14Z")
![Screen Shot 2021-08-17 at 11.23.36 AM](https://global.discourse-cdn.com/coda1/original/3X/3/8/38cc1f751c8725665bdf6ce8415c9925a5e7ba5a.png) 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. ---
**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\ **Post date:** [August 17, 2021, 4:18pm UTC](https://connect.superhuman.com/t/make-countif-count-the-number-of-elements/25079/2 "2021-08-17T16:18:53Z")
👋 Hey there! Welcome to Coda! This should do what you are looking for: https://coda.io/embed/9A4UPCLDlg/_sueJp?viewMode=embedplay 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