SUMIFS Multiselect Dropdown

Creating an estimating sheet, that selects multiple people to a task. Each "role" has a different billable "rate"

Sheet #1: "DATA"

2 Columns: Roles and Billable Rates

~ 10 roles, changes per project

Sheet #2: "Select & Summary"

2 Columns:

Assignee: Multiselect drop down or each role. (would love a VLOOKUP for the dropdown...but a different ask)

Billable Rate: Would like it to sum the Roles selected for a combined hourly rate.

My attempt....

=SUMIFS({Rates Range}, {Roles Range}, CONTAINS(@CELL, INDEX([Assignee], MATCH(Assignee@row, {Roles Range},0))))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!