CountIf for a list

[Christien_Louviere]

How can I count the total number of “Yes” and "No"s across a dropdown?

[Pch]

Hi @Christien_Louviere !

One way to do this would be to use something like …

For the Yes :
(See the formula in the field [Total - Yes] in the sample below)

ListCombine(
  thisRow.[Select 1],
  thisRow.[Select 2],
  thisRow.[Select 3]
).CountIf(CurrentValue = Yes)

And for the No:
(See the formula in the field [Total - No] in the sample below)

ListCombine(
  thisRow.[Select 1],
  thisRow.[Select 2],
  thisRow.[Select 3]
).CountIf(CurrentValue = No)

… where in both formulas, CurrentValue represents each specific text value currently selected in each select list in thisRow … which is then counted if it’s equal to Yes in the 1st formula and No in the 2nd one

I hope this helps