How can I use N/A in a formula as not to get an error message, but an actual
number back ?

For example when adding up cells and then dividing by a number and one of
the cell values is N/A, because it is not applicable.

Thank you