Summing a column of Numbers

[FLKULCHAR]

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

#N/A in it.

Thanks,

FLKULCHAR

 

[RagDyer]

Try this:

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

--
HTH,

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

 

[FLKULCHAR]

thanks

Try this:

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

--
HTH,

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

 

[RagDyer]

You're welcome!

 

[Lou]

WOW!
Lots to learn here!
Lou

Try this:

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

--
HTH,

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