October 5, 2019
Hi, I am wanting to count how many of the columns for each row have a "true" value. Up to now I have created a custom column for each column that had true/false by giving true a value of one and false 0 and then deleted the original column. Finally i summed the total.
This time I have a lot of columns and so don't want to go through that long process but count the number of true.
Is there a formula that I can use that recognises true and can count them?
thanks so much, Mike
July 16, 2010
Duplicate the query, then unpivot the columns containing TRUE/FALSE.
Filter the duplicated query for only TRUE rows and remove the column containing the original column headers.
Then Group By > Count.
Lastly, merge the queries together bringing in the count column.
See example file attached.