| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sum column containing words and numbers
I have one column of imported data that contains about 12000 rows of text and
numbers. I would like to find out the dollar total of the numbers only, BEFORE i start formatting the data (text to columns, etc). Because the dollar total will be in the the millions I would like to have a reference dollar total so that I know if I have made a mistake at anytime i.e. accidentally delete a row. Is it possible to find a sum first? Any help is greatly appreciated :) Trina |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto generate numbers in decending order in a column | New Users to Excel | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
| Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions | |||
Threaded Mode
