How can I count the number of “true” responses in a row?
like in a “countif” command in a spreadsheet?
Thank you.
If the column type is Y/N and you have lot of columns…
LEN(SUBSTITUTE([Col1]&[Col2]&[Col3],“FALSE”,""))/4
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |