# Find from a list from within a form

**URL:** https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106
**Category:** Ask for Help
**Created:** [June 18, 2021, 4:25am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106 "2021-06-18T04:25:39Z")
**Posts on this page:** 1
**Showing post:** 27

<div class="post-metadata">

### Author: ![abe.sherman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abe.sherman/32/11260_2.png) [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [July 5, 2021, 4:29pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/27 "2021-07-05T16:29:06Z")

</div>

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fcdbf6ed0b779e39acfc453b5b645cedace103cf.jpeg "Glide inventory Math challenge in glide") ](https://www.youtube.com/watch?v=9JQeVSu46Pw)

Math needed in glide for fast results.  
Convert this to inglide math.

COUNT/COUNT UPC IN ORDER DOWN   
=ARRAYFORMULA(IF(K2:K\<\>“”,COUNTIFS(K2:K,K2:K,ROW(K2:K),“\<=”&ROW(K2:K)),“”)-1)  
COUNT/COUNT DDNS   
=ARRAYFORMULA(IF($K2:$K\<\>“”,COUNTIFS($B2:$B,$B2:$B,ROW($B2:$B),“\<=”&ROW($B2:$B)),“”))  
COUNT/COUNT UPC On JOB SITE   
=ARRAYFORMULA(if(ISBLANK(B2:B) \<= false,COUNTIFS($K2:$K&B2:B,“”&$K2:$K&B2:B,ROW($B2:$B),“\<=”&ROW($B2:$B)),0))  
COUNT/JOB SITE TOTAL   
=ARRAYFORMULA(if(ISBLANK(B2:B) \<= false,COUNTIFS($K2:$K&B2:B,“”&$K2:$K&B2:B,ROW($B2:$B),“\<\>”&ROW($B2:$B))+1,0))  
COUNT/ALL TOTAL PRODUCT  
=ARRAYFORMULA(IF(K2:K\<\>“”,COUNTIFS(K2:K,K2:K,ROW(K2:K),“\<\>”&ROW(K2:K)),“”))

> [@What are all formula you can use with math?](https://community.glideapps.com/t/what-are-all-formula-you-can-use-with-math/28747):
>
> Hi guys i would like to collect data on what you can do with math. If there is any other way to calculate things besides +,-,\*,/ I feel like this info is missing in glide. Lets say i want to calculate how many times a name is appeared over again. would that be possible? Compare a col to another. If Something = to something? You get the point. Can we share all knowledge if it exist and if we are able to here. Math should be a big subject. And we should be able to do much more then we currently a…

---

_[View the full topic](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106)._