Column has entires that are both numerical and "#N/A". The SUM formula at the bottom of the column will not total the numeric entries because of the #N/A cells. Is there a way to total all the cells that have a numeric entry only? The cells will change from #N/A to a number as entries are made in other columns.