What formula will eliminate the cell with #N/A when summing?
N Nunzio Aug 12, 2006 #3 Thank you it worked good Toppers said: =SUMIF(A1:A10,"<>#N/A",A1:A10) Click to expand...