How to count tasks occurring over a date range based on another column parameter selected

Dan Harris

Trying to set up a formula to count tasks happening during a date range based on another cell drop down ie approved, not approved etc, any ideas?

Thanks

Tim Radosevich

Hi Dan,

I just nest my COUNTIF's statements in my IF's statements and then nest them all together.... here is an example with 3 statuses and the final COUNTIF result is based on the all the statements nested together...

Mike Wilday

You can also create a COUNTIFS formula that checks each range. The following formula will check for any date within the calendar year, that also has "Approved" in the dropdown column. Just update the column names with your own column names. (Use brackets if your columns contain spaces or end in a number.)

=Countifs([Name of Date Column]:[Name of Date Column], > Date(2020, 01, 01), [Name of Date Column]:[Name of Date Column], < Date(2020, 12, 31), [Name of Dropdown Column]:[Name of Dropdown Column], "Appproved")