# 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:** 8\ **Page:** 1
**Author:** ![Shmuel\_Munitz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shmuel_munitz/32/31720_2.png) [@Shmuel\_Munitz](https://community.glideapps.com/u/Shmuel_Munitz)\ **Post date:** [November 17, 2021, 11:27pm UTC](https://community.glideapps.com/t/adding-rows/34679/1 "2021-11-17T23:27:25Z")
Hi, my google sheet has sum ifs and interactions between pages. But when I add a row to my sheet via is there a way to get that sum if cell to be added to the row as well? Otherwise my app will not be very usefull for me. ---
**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 ---
**Author:** ![Jesus\_Valenzuela\_Dia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesus_valenzuela_dia/32/22582_2.png) [@Jesus\_Valenzuela\_Dia](https://community.glideapps.com/u/Jesus_Valenzuela_Dia)\ **Post date:** [November 17, 2021, 11:31pm UTC](https://community.glideapps.com/t/adding-rows/34679/3 "2021-11-17T23:31:58Z")
Hi @Shmuel_Munitz you should use array formulas. [ARRAYFORMULA - Docs Editors Help](https://support.google.com/docs/answer/3093275?hl=en) ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [November 17, 2021, 11:37pm UTC](https://community.glideapps.com/t/adding-rows/34679/4 "2021-11-17T23:37:06Z")
You could use Arrayformula with Sumif… i.e. =arrayformula(if(isblank(A2:A),"",SUMIF(Sheet1!C:C,A2:A,Sheet1!D:D))) ---
**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:** [November 18, 2021, 12:00am UTC](https://community.glideapps.com/t/adding-rows/34679/5 "2021-11-18T00:00:27Z")
Do you absolutely need those numbers in the Sheet or are you willing to move the logic into Glide computed columns? ---
**Author:** ![Shmuel\_Munitz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shmuel_munitz/32/31720_2.png) [@Shmuel\_Munitz](https://community.glideapps.com/u/Shmuel_Munitz)\ **Post date:** [November 18, 2021, 12:14am UTC](https://community.glideapps.com/t/adding-rows/34679/6 "2021-11-18T00:14:06Z")
That seems simpler, how would I do that? ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [November 18, 2021, 12:42am UTC](https://community.glideapps.com/t/adding-rows/34679/7 "2021-11-18T00:42:45Z")
This may help: > **[Math Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column)** > > Performs instant calculations on your data 😀 ---
**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:** [November 18, 2021, 12:46am UTC](https://community.glideapps.com/t/adding-rows/34679/8 "2021-11-18T00:46:34Z")
Since you have IF in there, I think it’s a combination of if-then-else and math/rollup columns. If you can describe your use case we may be able to help.