Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Formulas
Easiest way would be to insert a new column to the right, then select the
range you want to sum and do datatext to columns, select delimited and click next, then select comma and click finish. Now just do a simple sum if you insist using bad spreadsheet design use =SUM(IF(ISNUMBER(FIND(",",A2:A10)),--SUBSTITUTE(A2:A10,MID(A2:A10,FIND(",",A2:A10),255) ,""))) needs to be entered with ctrl + shift & enter replace A2:A10 with your range -- Regards, Peo Sjoblom "Angela" wrote in message ... I have data where it is sorted by dated and I wanted to subtotal the number of plants that we delivered for a specific date. The problem is the exported data has numerals and text. (Example below.) So when I try and do a simple sum it isn't. Can someone help me with how to get it to just sum the number. I believe for the most part it is just the 1st or 1st and 2nd characters of the field. I thought I read somewhere that you can just pull the numbers out but as in the 1st example the pot size is showing up as well and I don't want that to be included. 16,Pothos Jade Green 06" 2,Aglaonema Silver Queen Thank you in advance, Sincerely Angela |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Formulas | Excel Worksheet Functions |