Forum Discussion
RANGE with SUM and XLOOKUP
Hello, I need support from a person who has installed WIN and Excel in us-US language. Unfortunately I do not have one available at the moment. The above data range (in green) is calculated us...
On a US English system, you should use comma as list separator:
=SUM(XLOOKUP(U5,Datum,West),XLOOKUP(V5,Datum,South))
Thanks, but this I tried too, but no positive result.