• 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


  • 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


New Member
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?