formula

M

Mark Ruiz

Does anyone know what the formula would be to add a column of numbers
excluding #N/A?

Office XP

Thnx,

MRuiz
 
J

jp

I good idea would be to stop it doing NAs?

Lookup the help for onerror!

Cheers

John

North Yorkshire
 
B

Bernard Liengme

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
 
Top