Select and sum all numbered cells in Column A

Lane Smith · Jan 30, 2011

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.

CurlyDave · Jan 30, 2011

this site explains how to use Special Cells to select just numbers in
a range and sum them
http://www.davesexcel.com/apps/foru...py-just-text-select-non-blank-cells?page=last

Dave Peterson · Jan 30, 2011

=sum(a1:a10)
or
=sum(a:a)

will ignore text entries in the specified range.

Select and sum all numbered cells in Column A

Lane Smith

CurlyDave

Dave Peterson