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