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 offices.
For example, if I selected “Austin” and “Tampa” in the cell of “Allocation” column, I will get the total personnel of 55 from the Office table. Please advise how to do this. Thanks in advance!!
Office# of PersonnelAustin15Dallas21Las Vegas16Tampa40San Jose28Total120
AllocationsTotal PersonnelAustin, Dallas, Las Vegas52Austin, Tampa55
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 offices. For example, if I selected “Austin” and “Tampa” in the cell of “Allocation” column, I will get the total personnel of 55 from the Office table. Please advise how to do this. Thanks in advance!! Office# of PersonnelAustin15Dallas21Las Vegas16Tampa40San Jose28Total120 AllocationsTotal PersonnelAustin, Dallas, Las Vegas52Austin, Tampa55 Read More