# SUMIFS Function Dynamic Filtering

**URL:** <https://community.ragic.com/t/sumifs-function-dynamic-filtering/5267>\
**Category:** Support\
**Created:** [June 24, 2020, 5:32pm UTC](https://community.ragic.com/t/sumifs-function-dynamic-filtering/5267 "2020-06-24T17:32:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![acheek](https://community.ragic.com/letter_avatar_proxy/v4/letter/a/0ea827/32.png) [@acheek](https://community.ragic.com/u/acheek)\
**Post date:** [June 24, 2020, 5:32pm UTC](https://community.ragic.com/t/sumifs-function-dynamic-filtering/5267/1 "2020-06-24T17:32:14Z")

</div>

Hi,

In the table below I am trying to calculate an pay period filtered total of scheduled deductions. Essentially the formula I am trying to use in the highlighted column is: “SUMIFS(E11,B11,”=“+TEXT(SUBTABLEROW(B11,G11)))”

 ![Annotation 2020-06-24 132604](https://community.ragic.com/uploads/default/original/2X/7/777b504844c213582b2691e31af032e315056218.png)

In Other words I want the sum of all entries in Column “This Period Deduction” if “Pay Period” equal the current row’s “Pay Period”.

Please let me know if this is possible and if so how can it be accomplished?

Thanks!

Andy

---

<div class="post-metadata">

**Author:** ![Angie](https://community.ragic.com/user_avatar/community.ragic.com/angie/32/1158_2.png) [@Angie](https://community.ragic.com/u/Angie)\
**Post date:** [June 26, 2020, 12:38am UTC](https://community.ragic.com/t/sumifs-function-dynamic-filtering/5267/2 "2020-06-26T00:38:09Z")

</div>

> [@acheek](#):
>
> In Other words I want the sum of all entries in Column “This Period Deduction” if “Pay Period” equal the current row’s “Pay Period”.

Would you mind to share a simple example in Excel for us to refer to?

---

<div class="post-metadata">

**Author:** ![acheek](https://community.ragic.com/letter_avatar_proxy/v4/letter/a/0ea827/32.png) [@acheek](https://community.ragic.com/u/acheek)\
**Post date:** [June 26, 2020, 12:16pm UTC](https://community.ragic.com/t/sumifs-function-dynamic-filtering/5267/4 "2020-06-26T12:16:50Z")

</div>

Angie,

[Here is the link](https://rdgeinc-my.sharepoint.com/:x:/g/personal/acheek_rdgrahamelectric_com/EbIizLWRYrNNsbwEYUZWZEkBZ8OrQSGVY7EwjLByJRTahg?e=O3amjM)

Thanks!

---

<div class="post-metadata">

**Author:** ![Angie](https://community.ragic.com/user_avatar/community.ragic.com/angie/32/1158_2.png) [@Angie](https://community.ragic.com/u/Angie)\
**Post date:** [June 26, 2020, 10:52pm UTC](https://community.ragic.com/t/sumifs-function-dynamic-filtering/5267/5 "2020-06-26T22:52:22Z")

</div>

Hi,

Thanks for the example.

We’re sorry that this kind o of formulas is not supported in Ragic since you won’t be able to refer to values of other subtable “rows”. If you would like to get the total of each date, I would suggest creating a child sheet via [new sheet from subtable](https://www.ragic.com/intl/en/doc/33/New-sheet-from-subtable) first. Then, generate [reports](https://www.ragic.com/intl/en/doc/36/Reports) based on the child sheet to get the total of each date.
