What's the formula for adding different cells from the same column? Ex.
a5+a22+a100

Les

In an unused cell type =A5+A22+A100 and hit the <ENTER key.

If those cells have numbers, you will get an answer.

OR you could use =SUM(A5+A22+a100) which ignores cells that are not numbers.

i.e. A5 = 123, A22 = 123, A100 = "les"

The SUM function would return 246

=A5+A22+A100 would throw an error.


Gord Dibben Excel MVP

On Tue, 15 Mar 2005 18:47:01 -0800, Les wrote:

What's the formula for adding different cells from the same column? Ex.
a5+a22+a100

=a5+a22+a100
if the cells are not contiguous.
or
=sum(a5,a22,a100)

=sum(a5:a100)
if you wanted all those cells summed.

Les wrote:

What's the formula for adding different cells from the same column? Ex.
a5+a22+a100

--

Dave Peterson