+ Reply to Thread
Results 1 to 2 of 2

Return Text based on Max Sum of number values by month

  1. #1
    Registered User
    Join Date
    11-29-2023
    Location
    Austin, TX
    MS-Off Ver
    Excel for Mac 365
    Posts
    1

    Return Text based on Max Sum of number values by month

    Hi,
    This is for Google Sheets.
    I need a formula that returns the text when using a sum max for a number by date.
    In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125).

    cell A1 1/31/2023 2/28/2023
    Result AA02 CCC

    data set
    Month Year SKU total
    1/31/2023 AA02 3995
    1/31/2023 MCT06 100
    1/31/2023 AA02 125
    1/31/2023 MCT06 125
    2/28/2023 AAA 100
    2/28/2023 AAA 100
    2/28/2023 AAA 100
    2/28/2023 BBB 250
    2/28/2023 BBB 250
    2/28/2023 CCC 900
    Last edited by AliGW; 11-29-2023 at 12:22 PM. Reason: Thread moved to the correct forum section.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Return Text based on Max Sum of number values by month

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Replies: 3
    Last Post: 10-27-2022, 03:36 PM
  2. Replies: 3
    Last Post: 03-11-2022, 06:57 AM
  3. Replies: 2
    Last Post: 10-13-2021, 06:30 AM
  4. Replies: 8
    Last Post: 05-16-2018, 01:00 PM
  5. [SOLVED] Return number of hours per month based on start and end dates
    By sparky1231 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2014, 12:33 PM
  6. Return name of month based on single digit number
    By fredthehead in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-09-2008, 04:46 PM
  7. Replies: 3
    Last Post: 09-25-2007, 10:26 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1