Detect Multiple Different Drop-Drown and Sum Them together in a cell

you may use the Join function instead of Sumifs. JOIN combines text from multiple cells into a single string, while SUMIFS adds up cells based on multiple criteria:

Formula used:

=JOIN( " " , C2:D2)

Expected result

Reference

• Join function