ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formula (https://www.excelbanter.com/excel-programming/278512-formula.html)

Mark Ruiz

formula

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

Office XP

Thnx,

MRuiz

formula

I good idea would be to stop it doing NAs?

Lookup the help for onerror!

Cheers

John

North Yorkshire

Bernard Liengme[_3_]

formula

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

All times are GMT +1. The time now is 08:17 AM.