Formula Question

LK Shook

I need to create a count formula that counts an item from a multi-dropdown column in another sheet. Not related to a string of information. Can anyone help? Thanks.

KPH

Do you want to count the instances of a particular text string within a multi-select dropdown column?

If so, the COUNTIF formula with a HAS function will probably do the trick. Something like this:

=COUNTIF([Column Name]:[Column Name], HAS(@cell, "Thing to Count"))

In this example, that formula would return "4" as "Thing to Count" appears 4 times in the Column called Column Name:

You could remove the "Thing to Count" from the formula and instead put this into another column like this:

The formula in the Count column is

=COUNTIF([Column Name]:[Column Name], HAS(@cell, [Look up]@row))

You replace the text to look up with a reference to the cell that contains the text.

KPH

Hi @LK Shook

Did I correctly understand what you needed? Did it work and make sense?