The formula which can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is "Sum". So, the correct answer is option C.
In MS-Excel, the alphanumeric values are ignored during a calculation. You need write only "SUM" and the range of the cells within brackets. Basically, this function adds the numbers of the cells and return the result. It is a built-in function and its category isMath/Trig Function.