# Multiple criteria sumif array formula with logic

**URL:** <https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155>\
**Category:** Ask for Help\
**Created:** [May 14, 2020, 7:07pm UTC](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155 "2020-05-14T19:07:48Z")\
**Posts on this page:** 1\
**Showing post:** 14

<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:** [May 16, 2020, 9:46pm UTC](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155/14 "2020-05-16T21:46:00Z")

</div>

Is there more to this 500 row thing or is it a formula issue???

> [@If x Then y Else Do Nothing](https://community.glideapps.com/t/if-x-then-y-else-do-nothing/9218):
>
> Hello, I’m not sure if this counts as a bug or a feature request, but it may be causing my app to crash. I have an if then else statement set up as follows: My hypothesis is that because the Else statement default is to Enter Value, even if nothing is inputted, Glide is autonomously creating new rows to the maximum allowed (500) and filling in these newly created cells with the rule. Glide choosing to create these rows results in a vicious loop, where a trigger of the If Then Else st…

---

_[View the full topic](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155)._