Sum ignoring cells with error

  • Thread starter Thread starter JRD
  • Start date Start date
J

JRD

How does one sum up values in a column ignoring cells that contain #N/A error?
 
=SUMIF(A:A,"<>#N/A")

for all errors

=SUMIF(A:A,"<"&99^99)





--


Regards,


Peo Sjoblom
 
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

XL2002 SUM with a twist... 4
Set add function ignore #N/A 1
Counting once more 2
Remove/Ignore Letters when Summing cells in a column. 3
Sums including #NAME? 2
SUM Formula 8
Counting blanks as zeros 1
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top