# COUNTIF between date range and 2 criteria

Options
✭✭
edited 08/08/22

I am trying to cross reference another sheet to count all of the projects assigned to a specific person in between a certain range, but the # of projects assigned and the person assigned to the project are 2 separate criteria.

For example, I want to know how many "A" projects that Jane completed in the month of January.

I have tried a handful of different formula combinations and I've done some digging through past community questions but I'm not quite sure where to even start from anymore lol.

Does anyone have a solution?

Any and all help is appreciated!

Thank you!!

Tags:

• ✭✭✭✭✭✭
Options

You're going to need something along these lines...

=COUNTIFS({Assigned To}, @cell = "Jane", {Project Type}, @cell = "A", {Date}, AND(IFERROR(MONTH(@cell), 0) = 7, IFERROR(YEAR(@cell), 0) = 2022))

• ✭✭✭✭✭✭
Options

You're going to need something along these lines...

=COUNTIFS({Assigned To}, @cell = "Jane", {Project Type}, @cell = "A", {Date}, AND(IFERROR(MONTH(@cell), 0) = 7, IFERROR(YEAR(@cell), 0) = 2022))

• ✭✭
Options

@Paul Newcome - this worked, thank you so much!!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• ✭✭✭
Options

Hi, I am having similar issues as the one resolved above and wonder if @Paul Newcome or anyone can guide me on where i am going wrong please, the two different variations i have tried (&both failed) are:

=COUNTIFS({AML Priority}, "High", {JTCL - Child / Parent Helper Row}, "Action", AND{Start Date}<= DATE(2024, 5, 1), NETWORKDAYS({Start Date}, MIN(DATE(2024, 9, 30),{End Date})) / NETWORKDAYS({Start Date}, {End Date})), ""))

=COUNTIFS({AML Priority}, "High", {JTCL - Child / Parent Helper Row}, "Action"), AND(IF({Start Date}:{Start Date}, >=DATE(2024, 5, 1), {End Date}:{End Date}, <=DATE(2024, 9, 30)))

I am looking to capture all items that are 'high' that have an end date between 01 May 2024 and 30 Sept 2024