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!