Concatenate every cell in a colum with condition

[danieledemidio]

Hi, I need to concatenate the text of every cell that is true to a condition. Anyone managed this?

[#2]

Use TEXTJOIN() function like =TEXTJOIN(", ",TRUE,IF(B1:B10=TRUE,A1:A10,""))

Or =TEXTJOIN(", ",TRUE,FILTER(A1:A10,B1:B10=TRUE))