M Mark Ruiz Oct 1, 2003 #1 Does anyone know what the formula would be to add a column of numbers excluding #N/A? Office XP Thnx, MRuiz
Does anyone know what the formula would be to add a column of numbers excluding #N/A? Office XP Thnx, MRuiz
J jp Oct 1, 2003 #2 I good idea would be to stop it doing NAs? Lookup the help for onerror! Cheers John North Yorkshire
B Bernard Liengme Oct 1, 2003 #3 Hi Mark Try this, it worked for me =SUMIF(A1:A100,">0") Hopefully you have no negative numbers. If there are, then =SUMIF(A1:A100,">0")+SUMIF(A1:A100,"<0") Bernard
Hi Mark Try this, it worked for me =SUMIF(A1:A100,">0") Hopefully you have no negative numbers. If there are, then =SUMIF(A1:A100,">0")+SUMIF(A1:A100,"<0") Bernard
