# Help with formula pls **URL:** \ **Category:** Ask for Help\ **Created:** [June 3, 2020, 3:48pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239 "2020-06-03T15:48:32Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Madaleno](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/madaleno/32/7177_2.png) [@Madaleno](https://community.glideapps.com/u/Madaleno)\ **Post date:** [June 3, 2020, 3:48pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/1 "2020-06-03T15:48:32Z")
Hi all, I’m having problems when trying to make an arrayformula from a SUMIFS formula that’s currently working, any ideas? ![Captura de pantalla 2020-06-03 a las 17.39.47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bf7c52adc9780c2cb68b4f9684466346f8db6bc4.png) (This is the one working) ![Captura de pantalla 2020-06-03 a las 17.41.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6551851eb6d6a5581ba9dc5cd0959fb23d13e8c9.png) (This is what happens with arrayformula, it seems to refer only to the first row? how can I fix that?) ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [June 3, 2020, 3:56pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/2 "2020-06-03T15:56:45Z")
SUMIFS is not supported with ARRAYFORMULA. I guess you should find alternatives or workarounds thanks to Google … ---
**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:** [June 3, 2020, 4:07pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/3 "2020-06-03T16:07:06Z")
Can you tell me in English what do the notations in the formula mean? You may also have a look at my script in this post to copy the formula down. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 3, 2020, 4:20pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/4 "2020-06-03T16:20:27Z")
I’m also noticing that your formula has A2 instead of the array A2:A. Not sure if that would help as like @Christophe_HK said, SUMIFS doesn’t work with array formulas. Only SUMIF does. You may be able to use SUMIF if you join column values together. ---
**Author:** ![Madaleno](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/madaleno/32/7177_2.png) [@Madaleno](https://community.glideapps.com/u/Madaleno)\ **Post date:** [June 3, 2020, 4:28pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/5 "2020-06-03T16:28:16Z")
Sure thing, they submit a form to ‘Completados’ pending approval, when admin approves **Completados!H2:H,TRUE()** checks if the email of the submitted form matches the email of the user **Completados!B2:B,A2** , and then sums the exp coming from all the submitted and approved forms **Completados!I2:I** Gonna check your tutorial 🙂 ---
**Author:** ![Madaleno](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/madaleno/32/7177_2.png) [@Madaleno](https://community.glideapps.com/u/Madaleno)\ **Post date:** [June 3, 2020, 4:28pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/6 "2020-06-03T16:28:35Z")
Yeah, also tried that but same happens ☹ ---
**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:** [June 3, 2020, 4:31pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/7 "2020-06-03T16:31:20Z")
It should work with the script and a trigger to copy it down. Hopefully my tutorial would help. ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [June 3, 2020, 5:42pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/8 "2020-06-03T17:42:32Z")
Use SUMIF. ---
**Author:** ![Madaleno](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/madaleno/32/7177_2.png) [@Madaleno](https://community.glideapps.com/u/Madaleno)\ **Post date:** [June 3, 2020, 9:03pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/9 "2020-06-03T21:03:20Z")
I don’t know if this was exactly how you meant but I fixed it with two separate formulas, one checking each condition and now it works with an arrayformula 😃 Edit: that didn’t work either, was working whether it was approved or not, but I think I could make it with this formula: ARRAYFORMULA(IF(LEN(A2:A),SUMIF(Completados!B2:B&Completados!H2:H,A2:A&TRUE,Completados!I2:I))) Thanks everyone! P.s. @ThinhDinh thanks a lot for the tutorial but scripting seems to be above my level for now, I was still trying to understand the way it works 😃 ---
**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:** [June 3, 2020, 11:40pm UTC](https://community.glideapps.com/t/help-with-formula-pls/10239/10 "2020-06-03T23:40:49Z")
Yeah that concatenating “&” inside should work, well done!