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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula excluding #N/A 2
Autonumber field in Excel that behaves the same as Access 0
Excluding a paragraph tag from spelling check 0
filter column unique for alphanumeric 6
Copy addition formula of non-consecutive horizontal cells 2
Sum Function When Formula Produces #N/A 2
Formula Array Help in VBA 3
Count Number of Unique Cells That Don't Have Certain Characters 0

Top