1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count with multiple column criteria and within date range

Discussion in 'Ask an Excel Question' started by Chets, Jan 11, 2019.

  1. Chets

    Chets New Member

    Messages:
    19
    Hi All

    I am trying to get count of Resources Type (Capital or Operating) if row is within certain month as specified in the Metrics tab.

    The uploaded sample includes 2 tabs - Resources and Metrics. Resources is a list of Person records and whether they are Capital or Operating. Each row has a Start Date and may have End Date. A person can existing multiple times if they have moved from Capital to Operating and vice versa. The second tab is metrics to count number of Persons by Capital or Operating in a given month.

    The Resource list will include tens of thousands of rows, so the formula needs to be efficient.

    What is the best formula?

    Thanks.

    Attached Files:

  2. Nebu

    Nebu Excel Ninja

    Messages:
    2,135
    Hi:

    Why can't you pull a pivot to summarise the data.

    Thanks
  3. Chets

    Chets New Member

    Messages:
    19
    I tried PivotTable but am unable to determine date condition.

Share This Page