Sum ignoring cells with error

P

Peo Sjoblom

=SUMIF(A:A,"<>#N/A")

for all errors

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





--


Regards,


Peo Sjoblom
 

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

Set add function ignore #N/A 1
XL2002 SUM with a twist... 4
Remove/Ignore Letters when Summing cells in a column. 3
Sums including #NAME? 2
Excel formula, sum the value cell and if empty cell left blank 0
SUM function that ignores "#VALUE" and error entries?? 2
Counting once more 2
Ignore text but not numerics on SUM() function 1

Top