View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lane Smith Lane Smith is offline
external usenet poster
 
Posts: 1
Default Select and sum all numbered cells in Column A

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.