Closed Thread
Results 1 to 4 of 4

Criteria With Countif or Sumif and Frequency Requirement

  1. #1
    Registered User
    Join Date
    05-16-2017
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    51

    Lightbulb Criteria With Countif or Sumif and Frequency Requirement

    Hello All,

    Is there a formula which will look into the Data Dump Tab and match from the Table Tab the Sold Mgr Name and Product listed under them in between the dates on top from the Table tab to the Data dump Table and return the account count from column A in the Data dump Tab. But it wonít count the account multiple times.

    Example if John sold a Notebook to Walmart, RiteAide, and Homedepot between 2016-01 to 2016-12 it should count Walmart, RiteAide, and Homedepo as 3 regardless if he sold a Notebook on 2016-02 and again 2016-06 and again 2016-09 and again 2016-12 for each account.
    In the attachment Iíll added what the answer should be for John if formula created works. The formula should work for the other Sold Mgr Names as well with just adjustment picking one of the other Sold Mgr Names.
    Iíve also put another tab with a different view of the Chart but it would be the same as the Table tab result if it would be easier to understand that view for you.

    I know the formula has to deal with Sum if of countif and with frequency.

    See attachment.

    I would greatly appreciate the help.

    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,053

    Re: Criteria With Countif or Sumif and Frequency Requirement

    How does this differ from the request in your earlier thread, please?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    05-16-2017
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    51

    Re: Criteria With Countif or Sumif and Frequency Requirement

    Quote Originally Posted by AliGW View Post
    How does this differ from the request in your earlier thread, please?
    It don't but it has a new update just wanted to make a new post since the user helping me out yesterday is in England and must be sleeping now so I want to see if anyone in this side (America) of the hemisphere has a chance to look at my post to help me.

    Thank you,

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,053

    Re: Criteria With Countif or Sumif and Frequency Requirement

    Duplicate thread closed (not allowed). Please post again with this new information to your original thread to bring it back to the top of the forum. Thanks.

    For anyone who can help, the original thread is here: https://www.excelforum.com/excel-for...-criteria.html

    EDIT: It's 5pm in England - I doubt that he or she is asleep ... Probably finishing work!!!
    Last edited by AliGW; 07-13-2017 at 12:08 PM.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-13-2017, 11:24 AM
  2. I want to get COUNTIF and then do SUM for my requirement - Reg.
    By bala04msw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-21-2016, 03:56 AM
  3. Countif and sumif with multiple criteria
    By csnyder10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2016, 02:30 PM
  4. SUMIF, COUNTIF with multiple criteria
    By montreal1775 in forum Excel General
    Replies: 5
    Last Post: 03-05-2010, 12:14 PM
  5. Countif or Sumif with multiple criteria
    By Eladamri in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-22-2006, 07:45 AM
  6. [SOLVED] multiple criteria with countif or sumif
    By Renee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2006, 09:05 AM
  7. [SOLVED] Multiple Criteria for COUNTIF and SUMIF
    By nils_odendaal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2005, 04:45 AM

Tags for this Thread

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