Home > OS >  Sum multiple arrays into one
Sum multiple arrays into one

Time:09-22

Been trying to tackle this issue for a couple days and without much progress.

I have a multiple date filter (or a query) which filters a date array: i.e. array of dates from 12.2020 to 01.2022 and multiple filters range (01.2021-02.2021, 05.2021-09.2021).

This process filters the dates and produces multiple filtered arrays. The pic of how it looks is attached.

The formula used to produce arrays =ARRAYFORMULA(IF((($F$5:$S$5>=QUERY($B$3:$D$4;"select C where B = "&D8&""))*(F$5:$S$5<=ARRAYFORMULA(FILTER($D$3:$D$4;$B$3:$B$4=$D$8))));1;0))

As you can see, it generate multiple arrays, depending on the amount of filters applied.

My question is following is it possible to sum these arrays into one with one formula? So I would get 1 array instead of multiple.

EDIT 1: enter image description here

  • Related