Home > Software design >  How to convert SUMIFS to Array Formula Google Sheets
How to convert SUMIFS to Array Formula Google Sheets

Time:01-25

I have been trying to Convert the SUMIFS formula into Array but its not working in google sheets then i tried to follow online instructions and i am unable to that.

I hope someone can help me to fix the fomrula:

Formula1:

SUMIFS('Employee Leave Setup'!$I:$I,'Employee Leave Setup'!$B:$B,$B2:B,'Employee Leave Setup'!$X:$X,K$1)

Formula2:

=ArrayFormula(if(len(B2:B), iferror(vlookup(B2:B,QUERY({'Employee Leave Setup'!B:X}, "SELECT Col1, COUNT(Col22) Group by Col1 label COUNT(Col22)"",0),2,),0),))")))))

enter image description here

  • Related