24 Eki 2024 ... This example shows such a case. Two XLookup functions are used as parameters in the SUM function. ... The formula in cell G28 is: = SUM (XLookup ( ...