Combining Xlookup and Sumif

[Ccrossed]

Hello!

Im currently trying to combine the use of xlookup and sumif for below sheet.

I thought of using sumif on the return array section of xlookup but I keep getting #value! error.

i just need to print the sum of cost for an id if it is found. I need it to be in conjunction with xlookup as it will then be added to a larger formula.

[#2]

@Ccrossed 

With XLOOKUP() return_array shall be an array of the same size as lookup_array, not scalar value which is returned by SUMIF(). Not sure what "larger formula" shall do but you need another combination.