+ Reply to Thread
Results 1 to 3 of 3

i need a formula for the sum of letters thart equal numbers

  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    UAE
    MS-Off Ver
    office 2010
    Posts
    1

    i need a formula for the sum of letters thart equal numbers

    I need function for the sum of letters that equals to numbers in in the schedule.
    that means in one row if N=12 and D=12 and M=7 and f=9 what will be the formula for sum of them all in one row
    Attached Files Attached Files
    Last edited by ERASHID; 04-13-2015 at 06:18 AM.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: i need a formula for the sum of letters thart equal numbers

    Not very clear..

    Can you please clarify what you want, and attach a sample workbook to work on.
    Cheers!
    Deep Dave

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: i need a formula for the sum of letters thart equal numbers

    Hi,
    Considering that you have data in row 2

    =sum(N2,D2,M2,f2)
    =N2+d2+m2+f2

    punnam

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for sum of cells which contain letters and numbers
    By Hussain Anees in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-09-2014, 05:33 AM
  2. Formula's used with numbers and letters
    By halgraham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2014, 09:35 PM
  3. [SOLVED] Summing letters that equal numbers
    By M. McGee in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2013, 03:12 PM
  4. Replies: 2
    Last Post: 09-28-2011, 12:07 PM
  5. [SOLVED] How do I count letters and numbers in a formula?
    By Todd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2006, 11:30 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1