How to Count total of Column within a column range if it includes TRUE

[Duncan_Tilka]

I have columns A B C D and I’d like to count each cell from those columns in 1 row that are TRUE, and output the total number as text or rich text or number entry

So if cell in column A B C is true then the output shows 3 as text

How can I do this?

[Darren_Murphy]

Are these boolean columns, or are they Text columns containing the word TRUE?

If boolean columns, you can use a Rollup column, counting true values.
If text columns, use a query column and filter where the column is TRUE, and then use a rollup on the query.

Update: oh, wait - these are 4 separate columns?
hmm, okay. In that case the easiest thing would be to make them boolean columns (if they aren’t already), and then use a Make Array column to create an array from the 4. You can then do a rollup on the array.

[Duncan_Tilka]

Hi there, so they are each boolean columns, and separate columns. And if using the Make Array Column, how would you go about doing this rollup on the array?

Thank you for your help!

[Jeff_Hager]

First you need to add each boolean column into the Make array column. The add a Rollup column and point it at your make array column. That should be it.