+ Reply to Thread
Results 1 to 8 of 8

Formula sum if double check for large value

  1. 03-03-2020, 03:57 AM #1
    daboho
    daboho is offline
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,279

    Formula sum if double check for large value

    From this picture
    In title A is double title
    If is double i want to sum
    A value is max value in A
    From this picture example title A in G9 and G13 is double and i chek value in column H if H13 value > H9 then i only sum H13
    Screenshot_2020-03-03-14-54-58-26_f90b96e7af3c5a594eb0c92de7fc5fe1.png 
    "ThankyouFor Attention * And Your Help!!"
    Reply With QuoteRegister To Reply
  2. 03-03-2020, 04:00 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Formula sum if double check for large value

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 03-03-2020, 04:10 AM #3
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Formula sum if double check for large value

    How about helper column? Is it posible?
    Quang PT
    Reply With QuoteRegister To Reply
  4. 03-03-2020, 05:23 AM #4
    daboho
    daboho is offline
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,279

    Re: Formula sum if double check for large value

    No dont using help column is mmult can solved
    Reply With QuoteRegister To Reply
  5. 03-03-2020, 06:00 AM #5
    Shareez Saleem
    Shareez Saleem is offline
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Formula sum if double check for large value

    Added helper column
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 03-03-2020, 06:45 AM #6
    daboho
    daboho is offline
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,279

    Re: Formula sum if double check for large value

    Shareez Saleem there is not way not using helper column
    Reply With QuoteRegister To Reply
  7. 03-03-2020, 06:44 PM #7
    daboho
    daboho is offline
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,279

    Re: Formula sum if double check for large value

    Please help
    Reply With QuoteRegister To Reply
  8. 03-04-2020, 02:42 AM #8
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Formula sum if double check for large value

    What is your concern about using a helper column?
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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 LARGE function and sort by a second criteria once a double value has been found
    By Master1991 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-31-2015, 02:19 PM
  2. double values for LARGE
    By jed_vii in forum Excel General
    Replies: 5
    Last Post: 03-10-2007, 06:40 AM
  3. Check for double entries in a row
    By Pierrot Robert in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 PM
  4. [SOLVED] Check for double entries in a row
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 08:05 PM
  5. Check for double entries in a row
    By Pierrot Robert in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  6. [SOLVED] Check for double entries in a row
    By Pierrot Robert in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] A double check, please
    By Stuart in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-21-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1