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 otherw…

Yes, SUMIFS is a pain. I love both ARRAYFORMULA and QUERY but they sometimes exhibit some weird behavior that drives me up the wall. Just today I was struggling with the QUERY always returning the first row, not matter what the filter condition. Solution was to set the header argument to 0. …

Here’s a thread where I just dealt with finding a work-around for SUMIFS. The link @Karim posted was one of the sources for my solution. [image] [HELP NEEDED] Building A Sales Leaderboard Hello, I am trying to build a sales leaderboard and I’m almost done with it, but t…

Solution to: COUNTIFS and SUMIFS not working with Arrayformula

Ask for Help

Jeff_Hager November 11, 2019, 7:18pm 3

Here’s a thread where I just dealt with finding a work-around for SUMIFS. The link @Karim posted was one of the sources for my solution.

Topic		Replies	Views
Copy SUMIFS to all columns (Using QUERY vs ARRAYFORMULA) Ask for Help	6	2017	December 8, 2019
Some functions don't work with Arrayformula Ask for Help	14	365	November 23, 2021
Adding Rows Ask for Help	7	341	November 18, 2021
Help with formula pls Ask for Help	9	877	June 3, 2020
Looking for advanced google sheet formulas Ask for Help	15	1504	March 12, 2020

Solution to: COUNTIFS and SUMIFS not working with Arrayformula

Related topics