COUNTIFS and Date Range

Shannon Scarbrough

Hi! I want to be able to create a formula that says:

COUNTIFS Employee Status equals "Active" AND Employee Type Equals "Full Time", but falls within the month of March (or any month after that)

Please help! Thanks!

Paul Newcome

Try something like this...

=COUNTIFS([Employee Status]:[Employee Status], @cell = "Active", [Employee Type]:[Employee Type], @cell = "Full Time", [Date Column]:[Date Column], @cell >= DATE(2021, 03, 01))

Shannon Scarbrough

Thanks Paul,

Below is the formula I typed in which works! But I am hoping to have this number give me from the range of March 1st - march 31.

=COUNTIFS({GB Users Source Sheet Range 1}, @cell = "Active", {GB Users Source Sheet Range 5}, {GB Users Source Sheet Range 4}, @cell >= DATE(2021, 3, 1))

Paul Newcome

You should actually be getting an error for that formula because you go

range/criteria/range/range/criteria

The criteria for a specific month within a specific year would be this...

AND(IFERROR(MONTH(@cell), 0) = 3, IFERROR(YEAR(@cell), 0) = 2021)

=COUNTIFS([Employee Status]:[Employee Status], @cell = "Active", [Employee Type]:[Employee Type], @cell = "Full Time", [Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) = 3, IFERROR(YEAR(@cell), 0) = 2021))