LinkBack URL
About LinkBacks
i have table which contain alphanumeric value as text(serving hot pot), i want get total number serving pot
i m attaching table for reference
i have table which contain alphanumeric value as text(serving hot pot), i want get total number serving pot
i m attaching table for reference
explain how you get 29 please?
Your explanation is a bit confusing...
You say that "FULL CD, 1/2CD..............ARE TEXT.........2500HP,45CMPL SHOLD CONSIDER AS TEXT"
then you say that "NUMBERS 1/2, 1/4, 3500,5000....VOLUME OF SERVING DISHES"
so, is 1/2 to ve viewed as text or value
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Im sorry value shoulbe 22 instead of 29Originally Posted by FDibbins
i m attaching table again with coloured number which should be calculated.
pls help me to get a vbacode or array/cse formula for sum function
Last edited by thahirkv; 04-24-2015 at 03:02 AM.
Hi,
Formula on C10 :
Function SumAlpha(rng As Range) As Single Dim mtx, total As Single, v1, v2 mtx = rng.Value For Each v1 In mtx For Each v2 In Split(v1, Space(1)) If IsNumeric(v2) Then total = total + v2 Next v2 Next v1 SumAlpha = total End Function
Formula:
=sumalpha(C2:C9)
Formula on D10 :
Formula:=sumalpha(D2:D9)
Regards
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
THANKU Its worked for meHi,
Formula on C10 :Function SumAlpha(rng As Range) As Single Dim mtx, total As Single, v1, v2 mtx = rng.Value For Each v1 In mtx For Each v2 In Split(v1, Space(1)) If IsNumeric(v2) Then total = total + v2 Next v2 Next v1 SumAlpha = total End Function
Formula:=sumalpha(C2:C9)
Formula on D10 :
Formula:=sumalpha(D2:D9)
Regards
You are welcome, thanks for the reputation point.
Regards
but code cannot save
please let me how to install the code
Capture6.JPG
Capture7.JPG
Capture8.JPG
Capture9.JPG
could u help me to resolve this
Last edited by thahirkv; 04-24-2015 at 05:04 AM.
You must save the file as a macro enabled workbook.
When you try to save the file, change the file type to this (.xlsm, not .xlsx)
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks