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

Office XP

Thnx,

MRuiz

I good idea would be to stop it doing NAs?

Lookup the help for onerror!

Cheers

John

North Yorkshire

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

"Mark Ruiz" wrote in message
...
Does anyone know what the formula would be to add a column of numbers
excluding #N/A?

Office XP

Thnx,

MRuiz