I have a large data set (>160K rows) with multiple customers, products, time periods, etc.  I need to sum values based on markets+time period+product.  I am using a vlookup formula to identify the specific string to sum, however without a sum formula, Excel returns the first value found.  I need a sum of the values meeting my critera.  

This is my vlookup formula that works if only a single value applies: =IFERROR(VLOOKUP(CONCATENATE($B$1,$D$13,$C21),Query!$A$1:$AE$150397,15,FALSE),"")  

I have tried variations of SUMIF formulas (like below) but only returns a non-summed value. 

=SUMIF(Query!$A$1:$AE$150397,(IFERROR(VLOOKUP(CONCATENATE($B$1,$D$13,$C20),Query!$A$1:$AE$150397,15,FALSE),"")),Query!$A$1:$AE$150397)

Any suggestions?