# Some functions don't work with Arrayformula **URL:** \ **Category:** Ask for Help\ **Created:** [November 23, 2021, 2:27am UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945 "2021-11-23T02:27:15Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![DanielBeaudoin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielbeaudoin/32/12476_2.png) [@DanielBeaudoin](https://community.glideapps.com/u/DanielBeaudoin)\ **Post date:** [November 23, 2021, 2:27am UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/1 "2021-11-23T02:27:15Z")
Is there an alternative for those functions, like sumifs…? I need it to be copied down… ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 23, 2021, 3:35am UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/2 "2021-11-23T03:35:02Z")
Give us the formula please. I’m not a genius of this, but I had several experiences with arrayformula Perhaps what you can’t do with query you can do with vlookup inside arrayformula ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 23, 2021, 6:31am UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/3 "2021-11-23T06:31:57Z")
The best alternative to to avoid them altogether, and do the rollups using Glide Computed columns 😉 A SUMIF in a Google Sheet usually translates into some combination of Template, Relation and Rollup columns in the Glide Data Editor. ---
**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 23, 2021, 2:30pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/4 "2021-11-23T14:30:02Z")
You could use Arrayformula with Sumif… i.e. `=arrayformula(if(isblank(A2:A),"",SUMIF(Sheet1!C:C,A2:A,Sheet1!D:D)))` One of the only reasons to use a GSheet formula like this is if you need to sum rows that you do not want connected to Glide in any way. Otherwise you would be much better off following @Darren_Murphy advice and build it with Glide computed columns. ---
**Author:** ![DanielBeaudoin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielbeaudoin/32/12476_2.png) [@DanielBeaudoin](https://community.glideapps.com/u/DanielBeaudoin)\ **Post date:** [November 23, 2021, 5:19pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/5 "2021-11-23T17:19:15Z")
This is an example of the formula: =SUMIFS(‘Sheet1’!$D$3:D; ‘Sheet1’!$A$3:A; A14; ‘Sheet1’!$F$3:F; “\<=”&today(); ‘Sheet1’!$G$3:G; “\>=”&today()) \*SUMIFS ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 23, 2021, 6:04pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/6 "2021-11-23T18:04:36Z")
=arrayformula(SUMIFS(F:F;G:G;"\<"&today();H:H;"\>"&today())) This works. But I don’t understand your 1st criteria (a14) ---
**Author:** ![DanielBeaudoin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielbeaudoin/32/12476_2.png) [@DanielBeaudoin](https://community.glideapps.com/u/DanielBeaudoin)\ **Post date:** [November 23, 2021, 6:23pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/7 "2021-11-23T18:23:38Z")
A3:A from the Sheet1 must be the same as A14 ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 23, 2021, 8:07pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/8 "2021-11-23T20:07:40Z")
OK then you just put A3:A; “=” &A14 Tell me if it works also to you ---
**Author:** ![DanielBeaudoin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielbeaudoin/32/12476_2.png) [@DanielBeaudoin](https://community.glideapps.com/u/DanielBeaudoin)\ **Post date:** [November 23, 2021, 8:56pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/9 "2021-11-23T20:56:16Z")
Yes it works. But that’s not my problem! 🙂 This formula works well but I want to use it as an arrayformula. Can I use a workaround? ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 23, 2021, 9:24pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/10 "2021-11-23T21:24:00Z")
I don’t understand, this is an array formula. You don’t want to use it as array formula but make it in a similar way? Can I know the reason? I mean what’s your goal If you use only glide columns you can do the same in this way Create a IfThenElse column Put the conditions you are in need If true put the value of the column D3 else 0 Then create another column type Roll and make the sum of the column IfThenElse That’s get the same result ---
**Author:** ![DanielBeaudoin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielbeaudoin/32/12476_2.png) [@DanielBeaudoin](https://community.glideapps.com/u/DanielBeaudoin)\ **Post date:** [November 23, 2021, 9:50pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/11 "2021-11-23T21:50:39Z")
SUMIFS don’t work with ARRAYFORMULA I wanna know if there’s a workaround. I will look if IfThenElse is working for me Thank You! ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 23, 2021, 9:52pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/12 "2021-11-23T21:52:15Z")
My friend, I tested this formula I sent you, it is working. ---
**Author:** ![DanielBeaudoin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielbeaudoin/32/12476_2.png) [@DanielBeaudoin](https://community.glideapps.com/u/DanielBeaudoin)\ **Post date:** [November 23, 2021, 10:00pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/13 "2021-11-23T22:00:50Z")
Doesn’t work here. Example: =arrayformula(if(isblank(A3:A);"";SUMIFS(‘Réservations’!$D$3:D; ‘Réservations’!$A$3:A; A3:A; ‘Réservations’!$F$3:F; “\<=”&today(); ‘Réservations’!$G$3:G; “\>=”&today()))) But Google say that it’s not suppose to work. I’m looking for a workaround… ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 23, 2021, 10:05pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/14 "2021-11-23T22:05:59Z")
because you didn’t make as I showed to you: https://player.vimeo.com/video/649242507?h=25003a9197&app_id=122963 ---
**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 23, 2021, 11:32pm UTC](https://community.glideapps.com/t/some-functions-dont-work-with-arrayformula/34945/15 "2021-11-23T23:32:44Z")
If you can share a sample sheet with dummy data and tell me how you want it to work maybe we can work out a QUERY solution. However, I still do think you can do this within Glide, and it’s better to do it that way.