Sumif formula on multiple drop down cell

Wilmer Loewen

Hi,

I need to add a sumif on a multiple drop cell so depending on what options i choose it will sum all options selected in drop down. Is that possible?

SteyJ

https://community.smartsheet.com/discussion/109844/sumif-formula-on-multiple-drop-down-cell

hello @Wilmer Loewen

Yes it is possible, do you mind sharing some more info?

we will need which drop down items you want to sum/count if they are selected, and the name of the column for the drop-down.