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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |