Mar 02 2022 11:52 PM
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
Mar 03 2022 02:07 AM
@lucie389 XLOOKUP returns the first value it finds. You could use SUM(FILTER( .... )) or just a SUMIF.
Mar 04 2022 04:01 AM