👋 Welcome! Introduce yourself and connect with your peers in Education to receive your industry badge.

Formula to count of items in a multi dropdown list

lcamacho19911 ✭✭✭
edited 03/15/24 in Education


The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion). 

I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple values.  I hope I explain well my point.

Luis from PR

colum with dropdown multiselect.JPG

Capture results.JPG

Best Answer