Help! SUM XLOOKUP for multiple items

Copper Contributor

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 

 

lucie389_0-1646293787588.png

 

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.