Forum Discussion
Help! SUM XLOOKUP for multiple items
Hello, It's been almost a day that I can't find how to sum the score of a given week with XLOOKUP. For instance for Week 9, I would like to know based on the next table what's the total score f...
lucie389 XLOOKUP returns the first value it finds. You could use SUM(FILTER( .... )) or just a SUMIF.
Thank you very much! So if I understood well, there is no way to use XLOOKUP for this automation. Will use SUMIF then.