Summing a column of Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I sum a large column of numbers when some of the cells within the
column contain...

#N/A in it.

Thanks,

FLKULCHAR
 
Try this:

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
thanks

RagDyer said:
Try this:

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Click to expand...
 
WOW!
Lots to learn here!
Lou

RagDyer said:
Try this:

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Click to expand...
 
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

Find last column matching criteria 2
Sum of rows in different columns 3
SUMIF with criteria "<>" & "=" 4
Sum the last 5 numbers in a column 6
Sum Values from different column 1
SAME RANGE...DIFFERENT FORMULA 2
Sum every Nth Row (almost working) 1
Counting once more 2

Back
Top