This function is necessary when you have a column with data where both the number of elements and the names of these elements are entered. The usual sum function will not work here because each cell contains different text. Therefore, the introduction of the new ‘Sum of Elements’ function will be an extremely useful innovation. Function will count all of the numbers in a column. Here is one way to write it: =SUMELM(range);