# Can we create an array COUNTIFs formula within Glide

**URL:** <https://community.glideapps.com/t/can-we-create-an-array-countifs-formula-within-glide/22714>\
**Category:** Ask for Help\
**Created:** [February 13, 2021, 6:18am UTC](https://community.glideapps.com/t/can-we-create-an-array-countifs-formula-within-glide/22714 "2021-02-13T06:18:31Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [February 13, 2021, 6:27am UTC](https://community.glideapps.com/t/can-we-create-an-array-countifs-formula-within-glide/22714/3 "2021-02-13T06:27:27Z")

</div>

Here is one way to do that:

- Create a template column that concatenates the values in every row of the two columns you are interested in. For example, lets say its a User table and you are interested in Age & Sex, then your template column would be something like ‘Age:Sex’, and then substitute the actual values in each row
- Next create a similar template column, but using the actual values you need to count. Again, for example, lets say you are looking for 10 year old males, then it would be “10:Male”
- Now create a multi-relation joining those two template columns
- Finally, create a rollup column counting the items in that multi-relation

---

_[View the full topic](https://community.glideapps.com/t/can-we-create-an-array-countifs-formula-within-glide/22714)._