| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
spit & sum comma delimted value
Thanks Rick. Works 100%. "Rick Rothstein" wrote: Are you allowed to use VBA code? If so, this User Defined Function (UDF) can do what you want... Function CommaSum(R As Range) As Double Dim X As Long Dim Parts() As String Parts = Split(R.Value, ",") For X = 0 To UBound(Parts) CommaSum = CommaSum + Parts(X) Next End Function To install it, press Alt+F11 to get into the VBA editor; once there, click Insert/Module from its menu bar; then copy/paste the above code into the code window that opened when you did that. You are done. Go back to your worksheet and, assuming your values are in A1, A2, etc., enter this formula in, say, B1... =CommaSum(A1) and copy it down. You can use the CommaSum function inside other functions just like you can do with the built-in worksheet functions. -- Rick (MVP - Excel) "Francois Taljaard" wrote in message ... Did try it the cell is actually a vlookup and the formula much run in a If formula. The data is not consistent it might look something like 20,400,20,30 = 470. Use the if statement to check for "=" if true I do a Mid to get the value (470), if false I need to sum (20,400,20,30). Cell: =VLOOKUP(Table_Default__ORDERBOM[[#This Row],[PRODUCT]],PRODUCTS!A:G,7) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CANNOT Import comma delimted, quote qualifed text file into Excel. | Excel Discussion (Misc queries) | |||
| how do I open a comma delimted file so that all the fields are se | Excel Discussion (Misc queries) | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
![Francois Taljaard[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
