Hi Brad,

To sum all the numeric values in a column of cells containing either numbers or #N/As, you can use the SUMIF function with the ISNUMBER function as the criteria.

Here are the steps to follow:

1. Select the cell where you want to display the sum.
2. Type the following formula:
   Code:

   =SUMIF(range,"0")

3. Replace "range" with the range of cells you want to sum. In your case, it would be the column of cells containing the values you provided.
4. Press Enter.

The formula will sum all the numeric values in the range and ignore any non-numeric values like #N/A.