Sum of values based on specific selections in drop down

WillLuecke

hello,

I am trying to find a way to add a sum of “Projected Hours” based on different selections in a drop down column.
EXAMPLE:

If Project 1 requires “Repair” I want projected hours to add 200, If Project 1 requires “Tune up” I wanted projected hours to add 100

If Project 1 requires “Repair” and “Tune up” I want it to add the 200 and 100 together in the projected hours. Being that the dropdown column listing the different requirements will have multiple options I want to be able to tie a value to whatever is selected and it spit out the total projected hours based off whatever requirements I select.
please help

Jgorsich

Depending on how many choices you have, this may be as simple as

=IF(FIND("repair", Column@row) > 0, 200, 0) + IF(FIND("tune up", Column@row) > 0, 100, 0)

Jgorsich

Depending on how many choices you have, this may be as simple as

=IF(FIND("repair", Column@row) > 0, 200, 0) + IF(FIND("tune up", Column@row) > 0, 100, 0)