I have a spreadsheet showing the results of 3 sales contests. I have pulled
data using V-look-up and am now trying to sum $ totals for each individual.
However, summing is not working because cells contain n/a. How do I work
around this?
Example:

Name contest 1 contest 2 contest 3 Total pay
Jane $300 N/A $200
Bill N/a $500 N/A
Sandra $200 N/a n/A

When I try to sum Jane's totals I end up with N/A because there is an N/A in
the column range.

Can anyone help?

Thanks!