# Count check-list
**URL:** https://community.glideapps.com/t/count-check-list/52597
**Category:** Ask for Help
**Created:** [October 26, 2022, 9:18am UTC](https://community.glideapps.com/t/count-check-list/52597 "2022-10-26T09:18:03Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@Lucien\_sangarne](https://community.glideapps.com/u/Lucien_sangarne)
#### Post date: [October 26, 2022, 9:18am UTC](https://community.glideapps.com/t/count-check-list/52597/1 "2022-10-26T09:18:03Z")
hello I am making a checklist with two criteria adapted and not adapted I would like that at the end it counts for me the number of compliant and non-compliant in the table sheet or in a Glide tablet
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 9:21am UTC](https://community.glideapps.com/t/count-check-list/52597/2 "2022-10-26T09:21:00Z")
your google translation is so bad that I really can’t figure out what you are saying… try it again with different words
---
### Author:  [@Lucien\_sangarne](https://community.glideapps.com/u/Lucien_sangarne)
#### Post date: [October 26, 2022, 9:55am UTC](https://community.glideapps.com/t/count-check-list/52597/3 "2022-10-26T09:55:22Z")
Sorry
After submitting,
i want to count the number of “true value” entrie.
I have sheet table.
I try with arrayformula with countIF. But it does not work.
Thank you for your help
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 9:58am UTC](https://community.glideapps.com/t/count-check-list/52597/4 "2022-10-26T09:58:46Z")
do you need help with google sheets formulas or Glide tables?
---
### Author:  [@Lucien\_sangarne](https://community.glideapps.com/u/Lucien_sangarne)
#### Post date: [October 26, 2022, 10:02am UTC](https://community.glideapps.com/t/count-check-list/52597/5 "2022-10-26T10:02:13Z")
It’s possible for two posibility.
I used to use sheets table.
I don’t really know glide table and its functions
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 10:04am UTC](https://community.glideapps.com/t/count-check-list/52597/6 "2022-10-26T10:04:32Z")
OMG… what language are you using that google Translate is not able to crack it?
I know when google translate from Polish to English it is a mess… LOL
I see your time… so is Asia
---
### Author:  [@Lucien\_sangarne](https://community.glideapps.com/u/Lucien_sangarne)
#### Post date: [October 26, 2022, 10:08am UTC](https://community.glideapps.com/t/count-check-list/52597/7 "2022-10-26T10:08:02Z")
I need help with google sheets formulas
Thks
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 10:10am UTC](https://community.glideapps.com/t/count-check-list/52597/8 "2022-10-26T10:10:10Z")
you have the right guy for the job lol… I’m really good with google sheets formulas… i just don’t know if such specific terms can be translated
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 10:14am UTC](https://community.glideapps.com/t/count-check-list/52597/9 "2022-10-26T10:14:04Z")
give me the formula that you are struggling with… and I will adapt to Glide
---
### Author:  [@Lucien\_sangarne](https://community.glideapps.com/u/Lucien_sangarne)
#### Post date: [October 26, 2022, 10:18am UTC](https://community.glideapps.com/t/count-check-list/52597/10 "2022-10-26T10:18:25Z")
Thks,
I try : =arrayformula (count.if(a2:a;“conforme”)
I want a result at each row
(I come from new caledonia,sorry)😊
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 10:21am UTC](https://community.glideapps.com/t/count-check-list/52597/11 "2022-10-26T10:21:11Z")
countif not count.if plus close )
---
### Author:  [@Lucien\_sangarne](https://community.glideapps.com/u/Lucien_sangarne)
#### Post date: [October 26, 2022, 10:24am UTC](https://community.glideapps.com/t/count-check-list/52597/12 "2022-10-26T10:24:05Z")
Sorry in french
The formula Is : “Nb.si”
When i write de formula
Arrayformula( nb.si(a2:a;“conforme”))
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 10:26am UTC](https://community.glideapps.com/t/count-check-list/52597/13 "2022-10-26T10:26:52Z")
sorry, but i do not know Nb.si
---
### Author:  [@Lucien\_sangarne](https://community.glideapps.com/u/Lucien_sangarne)
#### Post date: [October 26, 2022, 10:27am UTC](https://community.glideapps.com/t/count-check-list/52597/14 "2022-10-26T10:27:31Z")
Thanks you for your help
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 26, 2022, 10:31am UTC](https://community.glideapps.com/t/count-check-list/52597/15 "2022-10-26T10:31:33Z")
so… it will be a count if… I recently did a French customer and I know… google has different formulas… arrayformulas has a different logic than stand-alone formulas
you need to use \* + to combine functions
I hope this will help you to google it… i can’t give you an exact answer without seeing whole matrix
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 26, 2022, 12:20pm UTC](https://community.glideapps.com/t/count-check-list/52597/16 "2022-10-26T12:20:30Z")
I would suggest using a Rollup column in glide to count true or false values in a column. It will be much faster and easier than using a google formula.
> **[Rollup Column](https://www.glideapps.com/docs/reference/computed-columns/rollup-column)**
>
> Perform calculations on columns or relations like count, average, and sum.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [October 28, 2022, 11:30am UTC](https://community.glideapps.com/t/count-check-list/52597/17 "2022-10-28T11:30:51Z")
@Lucien_sangarne
Bonjour Lucien, comme le suggère Jeff, vous pourriez travailler dans Glide Table plutôt que Google Sheets, l’approche est plus simple. Dans Glide Table, utilisez la colonne “rollup” pour compter un nombre d’éléments par colonne.
N’hésitez pas à poser vos questions en français dans le forum 👍