Forum Discussion
Solved
calculate sum based on the multiple selections from a reference table
I have a reference table, "Office" and like to get the total personnel based on the selection of offices in the "Allocations" table where I have the data validation configured to select multiple offi...
in F4, with 365:
=SUM(
XLOOKUP(
TEXTSPLIT( [@Allocations], ", " ),
Office[Office],
Office['# of Personnel],
0
)
)
