+ Reply to Thread
Results 1 to 4 of 4

Return the sum of the two highes values or the single value

  1. #1
    Forum Contributor
    Join Date
    04-22-2011
    Location
    Isabela, Puerto Rico
    MS-Off Ver
    365 Mac Excel Version 16.54
    Posts
    233

    Return the sum of the two highes values or the single value

    Hi there, may someone can help me with this, what i have is a formula to return the sum of the 2 highest values. if possible i need to change the formula tu also return a single value if there is just that one value, on the attached file on sheet 1 is what i have and on sheet 2 is what i will like it to be, i have values on the row range 3:9 and want to have the sum of the to highes values or the just one single value on the range of cels M3:M9 Eg. M9, I have attached a file for a better reference, many thanks for any help.
    Attached Files Attached Files
    Last edited by score; 11-29-2012 at 08:09 PM.

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Return the sum of the two highes values or the single value

    How about:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Contributor
    Join Date
    04-22-2011
    Location
    Isabela, Puerto Rico
    MS-Off Ver
    365 Mac Excel Version 16.54
    Posts
    233

    Re: Return the sum of the two highes values or the single value

    ConneeXionLost, very nice, just what i needed, many many thanks!!!

    Quote Originally Posted by ConneXionLost View Post
    How about:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Return the sum of the two highes values or the single value

    Slightly shorter..

    Please Login or Register  to view this content.
    or even shorter
    Please Login or Register  to view this content.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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