Can we create an array COUNTIFs formula within Glide

Ask for Help
1

Hi all, I would like to create an array countif formua within Glide. Basically, I want to count the number of rows that meet 2 requirements for each user (row).
I can’t do this in GSheets as the IFs requirements use LOOKUP data that is in Glide’s data editor and not in GSheets.

Looking forward to any advice. Thank you.

2

Have you tried using Rollup column based on a relation in Glide?

1 Like
3

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
7 Likes
4

Here you have a demo app implementing @Darren_Murphy idea in a dynamic way: you can select which age and which sex you want to count

4 Likes
5

Thanks guys. This is a good direction to move in. Will try it out and update!

1 Like