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.
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.