Share this topic
LinkedIn
Twitter
Copy URL
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
never-displayed