Select and sum all numbered cells in Column A
=sum(a1:a10)
or
=sum(a:a)
will ignore text entries in the specified range.
On 01/30/2011 17:05, Lane Smith wrote:
In columnA I have a mixture of numbers and and text in cells, I would
just like to sum the numbers in the column and place the value in
another cell
ColumnA
1
2
3
4
r
t
y
6
7
8
9
Get sum of the numbers
Thanks to all.
--
Dave Peterson
|