Adding Rows

[kyleheney]

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

Hey Gliders 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