Count formula for Multi Select AND checkbox

Dan_H

Hi!

I am currently looking to see if there is a formula that will give me a count outcome based on

1) A certain text in a multi select drop down (language)

PLUS

2) if a checkbox is ticked for that same row

So I am looking for the total of number of "Specific Language Speakers" in a multi select with a checkbox ticked in the same row but seperate column

Can anyone help I've had a few goes at it and its really not coming to fruition :)

Dan W

=COUNTIFS(Multiselect:Multiselect, HAS(@cell, "Specific Language Speakers"), CheckBox:CheckBox, =1)

Dan W

=COUNTIFS(Multiselect:Multiselect, HAS(@cell, "Specific Language Speakers"), CheckBox:CheckBox, =1)

Dan_H

This is unbelievably helpful issue resolved thank you!!!!

Dan W

Excellent glad to help!