formula

  • Thread starter Thread starter Mark Ruiz
  • Start date Start date
M

Mark Ruiz

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
 
You must log in or register to reply here.

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
filter column unique for alphanumeric 3
Formula Array Help in VBA 3
Sum Function When Formula Produces #N/A 2
calculate number of days formula 11
NTTP 1
Openning Word 1
count dates 1

Back
Top