Hi,
I am trying VLOOKUP with Multiple Criteria in Google Sheets Using ArrayFormula, since there are more than one value on the table.
I need to SUM UP all the numbers that matches the criteria.
Could you tell me where I can add "SUM" into the below formula? Truly appreciated it
=ArrayFormula(iferror(VLOOKUP($H$2&H3,{$B$3:$B&$D$3:$D,$E$3:$F},3,0),0))
Bookmarks