G Guest Aug 12, 2006 #3 Thank you it worked good Toppers said: =SUMIF(A1:A10,"<>#N/A",A1:A10) Click to expand...