Solve : None?

1.	Solve : None?
Answer» Hi, How do I sum a column in Excel that is filled with the #N/A symbol...for example, I have a column with 52 cells. Of those 52 cells, right now only 3 have NUMERICAL values (that were GENERATED from lookup table), but the REST have the #N/A in them. Because all the cells do not have numbers in them, the column will not sum, THUS preventing me from further formulas...any help is appreciated. Thanks!

Discussion