Couting only certain rows

Ask for Help
1

Hi pros!

i wanna do something in the built in table:

I have a column where it can either be “n”, “h” or “y”.
I wanna calculate the amount of “y”:s in it, but only the rows where another column have the cell values “energy”.

Anybody knows? The GPTS out there have no idea of what they’re talking about on this, which is very common when asking them about glide stuff.

Cheers

2

Welcome back :wave:

In short: query column + rollup column.

Try using a Query column, filter for your conditions, this should return exactly the rows you want to count. Then use a rollup column configured to “count” on the Query you just created.

4 Likes
3

Thank you!

Thanks for the fast response, this seems promising, it’s time I learn about the Query!

1 Like