# Multiple criteria sumif array formula with logic **URL:** \ **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:** 4\ **Page:** 2
**Author:** ![Kefa\_Kabanga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kefa_kabanga/32/5634_2.png) [@Kefa\_Kabanga](https://community.glideapps.com/u/Kefa_Kabanga)\ **Post date:** [May 18, 2020, 4:38pm UTC](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155/21 "2020-05-18T16:38:42Z")
Hi Thinh, Does this mean there’s no solution to using Arrayformulae in Glide without exceeding the free allowance as Google Sheets just adds 500 rows by default (which are then filled automatically by the Arrayformulae)? Also, this seems to happen on only one of my sheets in Google Sheets - all others add only one new row when new data from a form is filled in the Glide app. Could you look at my post / app to see if my issue is solvable in a similar way to this, or if it’s a different issue entirely? Thanks ---
**Author:** ![Ed\_V](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_v/32/2667_2.png) [@Ed\_V](https://community.glideapps.com/u/Ed_V)\ **Post date:** [May 18, 2020, 6:06pm UTC](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155/22 "2020-05-18T18:06:59Z")
No worries at all. Yes there is quite a complex set of references across a number of sheets so this may be causing the issue. It’s strange though as it wasn’t showing this heavy background calculation before adding the script and turning on iterative calculations - I imagine it’s the iterative calculations that may be to blame. Anyway, thanks so much for your help!! It’s been immensely helpful! If I can’t solve it I’ll make a separate post as it’s a bit out of scope of the original topic. ---
**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 18, 2020, 7:07pm UTC](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155/23 "2020-05-18T19:07:51Z")
> [@Arrayformula storage issue](https://community.glideapps.com/t/arrayformula-storage-issue/9213/11): > > OK, I think I understand this a little better now. I don’t think I realized that your sheet was built from a unique formula. I think the rows are being created by google when the UNIQUE formula hits the end of the sheet and automatically adds the 500 rows as a buffer. I think what we have here is a non-issue. Since your are only building the sheet from a unique formula instead of a from a form button (this is what I thought was happening), you really don’t have to worry about the extra rows … ---
**Author:** ![Ed\_V](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ed_v/32/2667_2.png) [@Ed\_V](https://community.glideapps.com/u/Ed_V)\ **Post date:** [May 27, 2020, 10:16am UTC](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155/24 "2020-05-27T10:16:43Z")
In case people were wondering I solved this through using an in-glide if, then, else formula. This doesn’t fluctuate 🙂 [Previous page](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155.md?page=1)