# Sumif=pain

**URL:** <https://community.glideapps.com/t/sumif-pain/22948>\
**Category:** Ask for Help\
**Created:** [February 17, 2021, 9:54pm UTC](https://community.glideapps.com/t/sumif-pain/22948 "2021-02-17T21:54:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Apto\_Cincodos](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/apto_cincodos/32/18458_2.png) [@Apto\_Cincodos](https://community.glideapps.com/u/Apto_Cincodos)\
**Post date:** [February 17, 2021, 9:54pm UTC](https://community.glideapps.com/t/sumif-pain/22948/1 "2021-02-17T21:54:48Z")

</div>

So I had this (obsolete, I know) formula that I was using to extract the $% distribution  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d8688714d8b6655f52cf90209f2f4823024e51b8.png)

so I can pull the amounts from here  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/8409947a9a65da09f947a304be35fbf511351449.png)

Now that I’m re-writing all my calculations through glide I wonder if there’s a simpler way to get this and how I can relate them to the user that is registered as well.

I tried a “math” column by each “department” where a single person is being earning but it quickly turned in a couple of dozen of colums just for 4-5 people.

I apologize if there’s anything unclear as I’m basically turning a new method through glide. I don’t know if these calculations must be done in the sheets but I don’t see it right since I already have cleared the “fees” and “net” worth of the project within glide, so there’s no writing of this in the sheets.

I appreciate any support on this. I freaking love glide and can’t wait to deploy all my previous system on this.

Naz,

---

<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:** [February 18, 2021, 12:08am UTC](https://community.glideapps.com/t/sumif-pain/22948/2 "2021-02-18T00:08:37Z")

</div>

Can you go through the logic behind the formula for us? Thank you.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 18, 2021, 1:03am UTC](https://community.glideapps.com/t/sumif-pain/22948/3 "2021-02-18T01:03:07Z")

</div>

To replace a SUMIF in Glide, you’ll probably need some combination of template, self-relation and rollup columns. The template and self-relation columns would apply the filtering you need, and then the rollup on that would get you the sum of the filtered records. Difficult to provide any more specific advice without some actual sample data to work with, and a definition of the filtering rules.