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 for this week and automate it with a function. Please help me out!
Many thanks in advance
2 Replies
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.
