Summing a column of Numbers
 

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!
==============================================


"FLKULCHAR" wrote in message
...
How do I sum a large column of numbers when some of the cells within the
column contain...

#N/A in it.

Thanks,

FLKULCHAR

thanks

"RagDyer" wrote:

Try this:

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

--
HTH,

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


"FLKULCHAR" wrote in message
...
How do I sum a large column of numbers when some of the cells within the
column contain...

#N/A in it.

Thanks,

FLKULCHAR

You're welcome!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"FLKULCHAR" wrote in message
...
thanks

"RagDyer" wrote:

Try this:

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

--
HTH,

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


"FLKULCHAR" wrote in message
...
How do I sum a large column of numbers when some of the cells within
the
column contain...

#N/A in it.

Thanks,

FLKULCHAR

WOW!
Lots to learn here!
Lou

"RagDyer" wrote:

Try this:

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

--
HTH,

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


"FLKULCHAR" wrote in message
...
How do I sum a large column of numbers when some of the cells within the
column contain...

#N/A in it.

Thanks,

FLKULCHAR