Q. In MS-Excel which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell

1. Count
2. Average
3. Sum
4. None of above