Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select and sum all numbered cells in Column A
this site explains how to use Special Cells to select just numbers in
a range and sum them http://www.davesexcel.com/apps/forum...ells?page=last |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select all odd-numbered rows in huge excel sheet? | Excel Discussion (Misc queries) | |||
create numbered sortable numbered list in excel | Excel Discussion (Misc queries) | |||
How to select only odd/even numbered rows to be shaded | Excel Discussion (Misc queries) | |||
How do I get the sum of only odd/even numbered cells in a column? | Excel Discussion (Misc queries) | |||
How to obtain sum of odd numbered column | Excel Programming |