Question

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?

Answer 1

Answer:

The SUM statement is used for the calculation of the sum of a range of cells. The plus point of this statement is that it automatically does not consider values which are alphanumeric, and only takes in to account numeric values.

Explanation:

please follow

Answer 2

Answer:

The SUM statement is used for the calculation of the sum of a range of cells. The plus point of this statement is that it automatically does not consider values which are alphanumeric, and only takes in to account numeric values.

mark me as brainlist...

Explanation:

hope it helps..