Iโm trying to find the count if a list of columns values for a record equals a certain text value (โXโ). The list formula would be as below. LIST([Column1], [Column2], [Column3], [Column4]).
Is there a way to count if any column in this list = โXโ without having to do an IFS for each column value?
IN(โXโ, LIST([Col1], [Col2], โฆ ))
Thank you @praveen
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |