Results 1 to 8 of 8

can i get code for sum of cells have alpha numeric value and other multiple factor

Threaded View

thahirkv can i get code for sum of... 04-24-2015, 01:17 AM
FDibbins Re: can i get code for sum of... 04-24-2015, 01:38 AM
thahirkv Re: can i get code for sum of... 04-24-2015, 02:54 AM
karedog Re: can i get code for sum of... 04-24-2015, 04:10 AM
thahirkv Re: can i get code for sum of... 04-24-2015, 04:30 AM
karedog Re: can i get code for sum of... 04-24-2015, 04:43 AM
thahirkv Re: can i get code for sum of... 04-24-2015, 05:00 AM
karedog Re: can i get code for sum of... 04-24-2015, 05:04 AM
  1. 04-24-2015, 02:54 AM #3
    thahirkv is offline
    Registered User
    Join Date
    04-18-2015
    Location
    london
    MS-Off Ver
    10
    Posts
    7

    Re: can i get code for sum of cells have alpha numeric value and other multiple factor

    Quote Originally Posted by FDibbins View Post
    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
    Im sorry value shoulbe 22 instead of 29
    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
    Attached Files Attached Files
    Last edited by thahirkv; 04-24-2015 at 03:02 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] using an alpha code for numeric value
    By alialee in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 01-17-2014, 05:36 AM
  2. [SOLVED] Sequential Alpha numeric code in batches, with spaces
    By joee74 in forum Excel General
    Replies: 5
    Last Post: 03-12-2013, 09:33 AM
  3. Convert alpha-numeric code to date
    By Buchu in forum Excel General
    Replies: 13
    Last Post: 06-04-2012, 12:51 PM
  4. Need help for a code in macro (to identify alpha numeric numbers)
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2012, 11:59 PM
  5. How do you create an alpha numeric code using data from other cells
    By jxking in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2010, 11:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1