# Ask about rollup
**URL:** https://community.glideapps.com/t/ask-about-rollup/70875
**Category:** Ask for Help
**Created:** [February 16, 2024, 7:00am UTC](https://community.glideapps.com/t/ask-about-rollup/70875 "2024-02-16T07:00:33Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Yoga](https://community.glideapps.com/u/Yoga)
#### Post date: [February 16, 2024, 7:00am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/1 "2024-02-16T07:00:33Z")
Hi everyone,
How can we count with a specified condition? I see in the rollup, there is only count without applying any condition there.
In my case, in a column, there are two kind of data written, which are “OK” and “Not OK”. How can I count the “Not OK” in that column?
In Excel, I would simply write this : =COUNTIF(A2:A1000,“Not OK”)
Thank you for your answer.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 16, 2024, 7:08am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/2 "2024-02-16T07:08:06Z")
You can use a Query column and apply a filter, and then do a rollup through the query.
Alternatively, instead of using “OK” and “Not OK”, use a boolean column. Then you could do a direct rollup counting `true` values.
---
### Author:  [@Yoga](https://community.glideapps.com/u/Yoga)
#### Post date: [February 16, 2024, 8:33am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/3 "2024-02-16T08:33:59Z")
Hi @Darren_Murphy thanks for your answer.
I don’t understand this Query function. How can we show this Query in Layout Editor? For example, from all 5 registered farmers (counted by total row only), there are 4 that the data is not completed. I use Query and filter the condition, and I get this result :
But how can I bring this result to interface / layout?
> Then you could do a direct rollup counting `true` values
This is conditional counting (count if true), I can’t do conditional counting in Glide Table.
---
### Author:  [@Yoga](https://community.glideapps.com/u/Yoga)
#### Post date: [February 16, 2024, 9:04am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/4 "2024-02-16T09:04:46Z")
> and then do a rollup through the query.
There’s no Query column in the Rollup option.
I think I missed something but I am not sure.
@Darren_Murphy
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 16, 2024, 9:07am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/5 "2024-02-16T09:07:40Z")
---
### Author:  [@Yoga](https://community.glideapps.com/u/Yoga)
#### Post date: [February 16, 2024, 9:09am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/6 "2024-02-16T09:09:53Z")
I see.
Voila! This is cool…
Thanks a lot @Darren_Murphy !
---
### Author:  [@Yoga](https://community.glideapps.com/u/Yoga)
#### Post date: [February 16, 2024, 9:49am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/7 "2024-02-16T09:49:13Z")
Hi @Darren_Murphy sorry I want to ask again,
Why is the field shown here is like this?
This “off farm” is not the thing I want to see here. I want to see “transaction\_id” on the queried column.
Why is the third column shown in the query, not the first column?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 16, 2024, 9:55am UTC](https://community.glideapps.com/t/ask-about-rollup/70875/8 "2024-02-16T09:55:25Z")
The value that you see in the query bubble doesn’t mean anything, other than telling you that the query matched something. It works like a multiple relation in that respect.
If you need a specific value, you should add a Single Value column that fetches the value via the query (in this case, the transaction\_id).