# COUNTIFS and Date Range

Options

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)

• ✭✭✭✭✭✭
Options

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))

• edited 03/31/21
Options

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))

• ✭✭✭✭✭✭
Options

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))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!