What happens if you write a formula that sums a range of cells, and one of the cells in the range displays #N$/$A$?$

Question $18$ options:

The sum will also show #N$/$A$.$

The sum will ignore the #N$/$A and calculate the sum of other cells.

The formula will result will be empty.

The formula will display the #VALUE error.