Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I total just the numbers in a column and ignore non-numeric strings?
I have a column of prices as shown and want to be able to total the
entire column. Sometimes some of the individual items are "included" and sometimes they are not. If they are not included in the main price I need to include their individual prices in the column total. If the items ARE included in the main price the word "included" will appear instead of the feature's individual price, but I still need to be able to total the column. The SUM function returns a #VALUE! error. Main price 240000 feature A 80000 feature B 9500 feature C Included Feature D 93000 TOTAL 422500 How can I sum a column that has at least one number in it although there may also me non-numerics in it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I total just the numbers in a column and ignore non-numeric strings?
Nevermind ... SUM works just fine ... I had a different (rather
stupid) problem. On Fri, 30 Jun 2006 06:52:19 GMT, Bud wrote: I have a column of prices as shown and want to be able to total the entire column. Sometimes some of the individual items are "included" and sometimes they are not. If they are not included in the main price I need to include their individual prices in the column total. If the items ARE included in the main price the word "included" will appear instead of the feature's individual price, but I still need to be able to total the column. The SUM function returns a #VALUE! error. Main price 240000 feature A 80000 feature B 9500 feature C Included Feature D 93000 TOTAL 422500 How can I sum a column that has at least one number in it although there may also me non-numerics in it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I ignore numbers and sort only text in an Excel column? | Excel Discussion (Misc queries) | |||
Making a particular cell or column required | Excel Discussion (Misc queries) | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
Formula to ignore negative numbers in a column? | Excel Worksheet Functions | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel |