Home > Software engineering >  Google Sheets sum of columns by matching 3 columns with one additional criteria
Google Sheets sum of columns by matching 3 columns with one additional criteria

Time:09-21

I want the sum of column E by matching column A,B and C with Column G,H and I where column D is Yes (answer in column J) and blank (answer in column K). Details given in below image.

Image of data

I had tried with the below formula but its not working:

=ARRAYFORMULA(SUMIF(FILTER(A3:A&B3:B&C3:C,D3:D=""),G3:G&H3:H&I3:I,FILTER(E3:E,D3:D="")))

The same formula is used for yes too in place of blank.

CodePudding user response:

=ARRAY_CONSTRAIN(MAP(G3:G,H3:H,I3:I,LAMBDA(g,h,i,SUM(FILTER(E3:E,g=A3:A,h=B3:B,i=C3:C,D3:D="Yes")))),COUNTA(I:I),1)

MAP the values from User Input and FILTER the Data by each value.

  • Related