Forum Discussion

Copper Contributor

Dec 22, 2022

Solved

XLookUp and Sum (Formula Support)

Hi there, I'm trying to create an attrition based formula using a combination of both XLOOKUP and SUM. In the attached example, I want to use the following calculation within a single cell: ...

XLookUpSUM Example.xlsx18 KB

excel

Formulas and Functions

Riny_van_Eekelen
Dec 22, 2022
E_D123 See attached!

XLookUpSUM Example.xlsx13 KB

Riny_van_Eekelen

Platinum Contributor

Dec 22, 2022

E_D123 I believe the formulas in the desired outcome section are wrong, so I changed them and completed the XLOOKUP formulas. See attached.

XLookUpSUM Example.xlsx12 KB

E_D123
Copper Contributor
Dec 22, 2022
Ah thanks for flagging, that was my mistake within the example.

Do you know how to capture the attrition % within the 'Current XLOOKUP Formula' section, so it's all within a single cell?
- Riny_van_Eekelen
  Platinum Contributor
  Dec 22, 2022
  E_D123 See attached!
  
  XLookUpSUM Example.xlsx13 KB
  - E_D123
    Copper Contributor
    Dec 30, 2022
    Riny_van_Eekelen Perfect- thank you!!