Help With COUNTIF Formula

System

This discussion was created from comments split from: Use Countif to count the number of tasks assigned to a worker?.

Allison Bishop

Hi,

=COUNTIF([Assigned Work]:[Assigned Worker], "contactname")

This formula is great. However, how would you incorporate a due date? I only want to count the items that are current (meaning not past the due date) for the assigned worker.

Thank you,

Allison

Genevieve P.

Hi Allison,

Instead of COUNTIF (singular), try COUNTIFS (with an S, plural), listing out each range and then criteria:

=COUNTIFS([Assigned Worker]:[Assigned Worker], "Contact Name", [Date Column]:[Date Column], >=TODAY())

This will only count items that are assigned to a specific person and also either have a date of Today or in the Future. Is that what you were looking for? You can take out the = sign in front of Today if you want to only look at future dates.

Here are some Help Center articles I used: COUNTIFS function / TODAY function / Formula tips and tricks

Cheers!

Genevieve