+ Reply to Thread
Results 1 to 2 of 2

Max, Sum If

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    Missouri
    MS-Off Ver
    Excel 2013
    Posts
    59

    Max, Sum If

    All,

    I have a master sheet with a timestamp (column A) and a product (column C). I would like to have a formula that spits out the day in which the most of a given product ("MS") were sold. This is in a GoogleDoc spreadsheet as well so I would like to keep the formula to a minimum. I know I could create a giant table with every day and the number of products sold, then do a max on the product sold column, then do a vlookup on that to find the date. But the table would just get too big if we are looking at a year or so.

    Example:

    11/1/2012 MS
    11/1/2012 MO
    11/1/2012 MS
    11/1/2012 MS
    11/2/2012 MS
    11/2/2012 MS
    11/3/2012 MS

    Record Day: 11/1/2012
    MS Sold: 3

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Max, Sum If

    did you tried countifs

    B7 = record day

    =COUNTIFS(A1:A10,"="&B7,B9:B12,"=MS")
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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