Sum like data when information is stored in multiple cells on the same row

Stu Benoff

Hi. Any suggestions on how to sum data when it is stored across multiple columns?

Each row contains up to three values and associated dollar amounts that come in via a form. I'd like to create a list of distinct values across all rows and sum the matching dollar amounts.

Any suggestions?

Thank you.

kowal

hi @Stu Benoff,

I would go for the formula =sumifs and add extra helping column with dropdpown list to choose multiple data so for example if from dropdown list is chosen value2, value3 it shall only sumiff those2 are chosen but not value3.

SUMIFS Function | Smartsheet Learning Center

hoep it helps.

Stu Benoff

Thanks for your response but how, in your example, are you associating value1 to dollar1 when using a multi-select field?