How can I count the number of "true" response...

(Jb Hanson) #1

How can I count the number of “true” responses in a row?

like in a “countif” command in a spreadsheet?

Thank you.

(Aleksi Alkio) #2

If the column type is Y/N and you have lot of columns…

LEN(SUBSTITUTE([Col1]&[Col2]&[Col3],“FALSE”,""))/4