# Adding Rows **URL:** \ **Category:** Ask for Help\ **Created:** [November 17, 2021, 11:27pm UTC](https://community.glideapps.com/t/adding-rows/34679 "2021-11-17T23:27:25Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 17, 2021, 11:31pm UTC](https://community.glideapps.com/t/adding-rows/34679/2 "2021-11-17T23:31:47Z")
In order for Sheet formulas to transfer to new rows, ARRAYFORMULAs need to be used. Unfortunately, I think SUMIFs have issues with ARRAYFORMULAs. There was a previous discussion here that might help: > [@Solution to: COUNTIFS and SUMIFS not working with Arrayformula](https://community.glideapps.com/t/solution-to-countifs-and-sumifs-not-working-with-arrayformula/1824): > > Hey Gliders wave During the past months while working on several Glide Apps I kept encountering the fact that Arrayformula, while incredibly practical, doesn’t work with SUMIFS() and COUNTIFS() functions. There are basically 2 main solutions: QUERY() is a great alternative in many cases otherwise SUMIF() and COUNTIF() with an & to concatenate several ranges and several criteria works aswell See example here: Hope this helps and happy gliding grin --- _[View the full topic](https://community.glideapps.com/t/adding-rows/34679)._