Forum Discussion
Combining Xlookup and Sumif
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...
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.