How to sum dropdown values in Google Sheets? - Excel Tips and Tricks

Discover how to sum dropdown values in Google Sheets? Formula featured in my video. =SUM(ARRAYFORMULA(IF(LEN(C5:C35) ＞ 0, SPLIT(C5:C35, " "),))) & " Apples" This formula sums the numeric values from the content of cells in the range C5:C35 after splitting each cell by spaces. It first checks if each cell is non-empty using IF(LEN(C5:C35) ＞ 0, ...). For non-empty cells, SPLIT breaks the content into parts where spaces occur, and the ARRAYFORMULA allows this operation to be performed across the entire range. The SUM function then adds up all the numeric values from the split results. Finally, the result is concatenated with the string " Apples", so the output is the sum followed by " Apples." #tips #excel #shorts #fyp