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

**URL:** <https://community.glideapps.com/t/how-to-count-total-of-column-within-a-column-range-if-it-includes-true/72787>\
**Category:** Ask for Help\
**Created:** [April 22, 2024, 11:37am UTC](https://community.glideapps.com/t/how-to-count-total-of-column-within-a-column-range-if-it-includes-true/72787 "2024-04-22T11:37:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Duncan\_Tilka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/duncan_tilka/32/62069_2.png) [@Duncan\_Tilka](https://community.glideapps.com/u/Duncan_Tilka)\
**Post date:** [April 22, 2024, 11:37am UTC](https://community.glideapps.com/t/how-to-count-total-of-column-within-a-column-range-if-it-includes-true/72787/1 "2024-04-22T11:37:12Z")

</div>

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? 🤔

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 22, 2024, 11:42am UTC](https://community.glideapps.com/t/how-to-count-total-of-column-within-a-column-range-if-it-includes-true/72787/2 "2024-04-22T11:42:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Duncan\_Tilka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/duncan_tilka/32/62069_2.png) [@Duncan\_Tilka](https://community.glideapps.com/u/Duncan_Tilka)\
**Post date:** [April 22, 2024, 3:27pm UTC](https://community.glideapps.com/t/how-to-count-total-of-column-within-a-column-range-if-it-includes-true/72787/3 "2024-04-22T15:27:05Z")

</div>

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?

 ![Screenshot 2024-04-22 at 11.26.43 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f484bf58ff2e51025e68da0334f5c70aa49ac160.png)

Thank you for your help!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 22, 2024, 3:39pm UTC](https://community.glideapps.com/t/how-to-count-total-of-column-within-a-column-range-if-it-includes-true/72787/4 "2024-04-22T15:39:12Z")

</div>

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.