# Complex count if **URL:** \ **Category:** Ask for Help\ **Created:** [June 19, 2020, 5:12pm UTC](https://community.glideapps.com/t/complex-count-if/11141 "2020-06-19T17:12:01Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [June 19, 2020, 5:12pm UTC](https://community.glideapps.com/t/complex-count-if/11141/1 "2020-06-19T17:12:01Z")
Hey guys Appreciate any help with a formula. I am looking to get the number of collectibles someone has that match a complete collection. Players are the people playing - where the value should be displayed. Collection is the amount of available collectibles and their owners. (there are multiple instances of the same item, but with a unique collectibleID) FullCollection is what a full collection looks like. My objective in the end is to use a progress bar to show how far the player is to get a full collection. > **[Playtest 2](https://docs.google.com/spreadsheets/d/1cySXXEgKOhW8xOTiautGTQEcwEo6rJ13WsFXVdrjlM0/edit?usp=sharing)** > > Players > > Username,Name,Picture,Location,Challenges Available,Completeness,Challenges available,Completeness > thomas@email.com,Thomas,Portand, OR, USA,0,0,0 > jorge@email.com,Jorge,Braga, Portugal,0,0,0 > sandrobrito@email.com,Sandro Brito,London,... ---
**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:** [June 20, 2020, 12:59am UTC](https://community.glideapps.com/t/complex-count-if/11141/2 "2020-06-20T00:59:17Z")
Hi Sandro, It’s the “Completeness” column right? I see you have an ARRAYFORMULA there. Is it not working? ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [June 20, 2020, 8:00am UTC](https://community.glideapps.com/t/complex-count-if/11141/3 "2020-06-20T08:00:38Z")
No, that was me trying to solve it but with no luck. ---
**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:** [June 20, 2020, 8:09am UTC](https://community.glideapps.com/t/complex-count-if/11141/4 "2020-06-20T08:09:20Z")
I don’t see any matching names from the Collection and FullCollection. Is there a problem there or am I missing something? ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [June 20, 2020, 11:25am UTC](https://community.glideapps.com/t/complex-count-if/11141/5 "2020-06-20T11:25:30Z")
apologies, the data on the collection was old as I was using mock data ---
**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:** [June 20, 2020, 11:48am UTC](https://community.glideapps.com/t/complex-count-if/11141/6 "2020-06-20T11:48:17Z")
Hi Sandro, I think I have managed to make it work. In the Collection sheet, I added a column to check if the collection in the row is in the FullCollection list or not. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4c1b063c404bc32f9d2d2fcc033264f06268b401.png) In the Players sheet, I used a combination of ARRAYFORMULA & QUERY to get what looks like what you need for your case. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/37d47f994a5119dd9d71b408aeb34783c71a09e1.png) Tell me if I can help more. ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [June 20, 2020, 11:56am UTC](https://community.glideapps.com/t/complex-count-if/11141/7 "2020-06-20T11:56:39Z")
Thank you so much again! ---
**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:** [June 20, 2020, 11:57am UTC](https://community.glideapps.com/t/complex-count-if/11141/8 "2020-06-20T11:57:32Z")
Have a nice weekend yourself 😄