+ Reply to Thread
Results 1 to 10 of 10

Summing letters that equal numbers

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Summing letters that equal numbers

    Can anyone provide a formula to sum letters that equal numbers? I would like to sum H=.50 and D=1 in a range of cells.

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Summing letters that equal numbers

    Try this...

    =SUM(COUNTIF(A2:A10,{"D","H"})*{1,0.5})
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    05-07-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Summing letters that equal numbers

    That didn't work. I am using a calendar to count days and half days that employees work. Would it interfere with your formula if there were numbers in some of the cells? I only want it to sum what the letters are equal to.

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Summing letters that equal numbers

    Quote Originally Posted by M. McGee View Post
    Would it interfere with your formula if there were numbers in some of the cells?
    Yes!

    How about posting SEVERAL representative examples so we can see what we're dealing with.

  5. #5
    Registered User
    Join Date
    05-07-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Summing letters that equal numbers

    I have attached an example of what I am trying to do.
    Attached Files Attached Files

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Summing letters that equal numbers

    There are no D's or H's anywhere in that book (not counting text strings like Wed and Thur and December and March)

  7. #7
    Registered User
    Join Date
    05-07-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Summing letters that equal numbers

    Sorry. Here is the correct example.
    Attached Files Attached Files

  8. #8
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Summing letters that equal numbers

    The formula I suggested does what you want you just need to use the correct range.

    Entered in K5 and copied down:

    =SUM(COUNTIF(A5:J5,{"D","H"})*{1,0.5})

    You just need to adjust for the correct range for each of your monthly sections.

  9. #9
    Registered User
    Join Date
    05-07-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Summing letters that equal numbers

    Thank you so much!

  10. #10
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Summing letters that equal numbers

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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