# How "Count IF"?

**URL:** <https://community.glideapps.com/t/how-count-if/29834>\
**Category:** Ask for Help\
**Created:** [August 1, 2021, 7:33am UTC](https://community.glideapps.com/t/how-count-if/29834 "2021-08-01T07:33:29Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [August 1, 2021, 7:33am UTC](https://community.glideapps.com/t/how-count-if/29834/1 "2021-08-01T07:33:29Z")

</div>

Hi, I barely dare asking this since the answer may be very basic, but I’m hitting my head on this one.

- Different assessors give a grade per project (yes, medium, no)
- I want to identify if a project has at least 1 “Yes” (ex. below, projects A - even if it has some "No - and C)

Title | Grade

* * *

**A** | **No**  
B | No  
C | YES  
**A** | **YES**  
**A** | **No**

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [August 1, 2021, 8:17am UTC](https://community.glideapps.com/t/how-count-if/29834/2 "2021-08-01T08:17:30Z")

</div>

create 3 columns with rows filled by Single Value yes… medium … no  
create 3 IF/ELSE column to check if grade column is one of these columns…  
than 3 roll up columns to to sum these IF/ELSE columns…  
you will know not only if at least 1 yes 1 medium 1 no is there… you will know exactly how many

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 1, 2021, 8:43am UTC](https://community.glideapps.com/t/how-count-if/29834/3 "2021-08-01T08:43:21Z")

</div>

If you only need to only know if it has a Yes or not, convert this to boolean (True/False) then use a rollup to count “Some True”.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db00e8cd58cde9b5e4f1581c874e8f4bfbb86839.png)

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [August 1, 2021, 9:13am UTC](https://community.glideapps.com/t/how-count-if/29834/4 "2021-08-01T09:13:33Z")

</div>

Thanks to you both @ThinhDinh @Uzo.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 1, 2021, 2:55pm UTC](https://community.glideapps.com/t/how-count-if/29834/5 "2021-08-01T14:55:53Z")

</div>

For this I would normally create a template joining Title and YES together. Then create a self relation linking that template back to itself. If the relation is not empty, then the project has at least one YES.

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [August 1, 2021, 5:02pm UTC](https://community.glideapps.com/t/how-count-if/29834/6 "2021-08-01T17:02:56Z")

</div>

Thanks @Jeff_Hager, I just need this basic info (the good ones above going beyond my basic need). Perfect!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/how-count-if/29834/7 "2024-01-17T16:51:07Z")

</div>