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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sum column containing words and numbers
SUM will ignore text.
=SUM(A1:A12000) -- Biff Microsoft Excel MVP "Tacrier" . wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sum column containing words and numbers
HI Trina,
you Can use this formula of sumif =sumif(totalrange,"<0",totalrange)+sumif(totalrang e,"0",totalrange) thanks Raj "Tacrier" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto sum column containing words and numbers
So, all your data is in one column, and you have mixed number and text
fields in there? Here is a link to a post from a couple of days ago which covers the same situation: http://groups.google.com/group/micro...8acd232843c6a# Hope this helps. Pete On Jun 26, 9:03*pm, Tacrier . wrote: 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 |
Reply |
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 |