Which formula can add the all the numeric values in a range of cells ignoring those which are not numeric and place the resulting a difference cell?

The alphanumeric values will already be ignored during a calculation in Excel sheet. So, any formula works. For example, if you got to take out the sum of cells A1 to F1, write =SUM(A1:F1).