Unparseble AND in a COUNTIFS

Box2105

I and trying to count rows where range 1 (last modified date) is 8 days ago AND range 2 (project status) = "In Progress"

=COUNTIFS(AND({Master Project List Range 1} > (TODAY() - 8)), Master Project List Range 2 = "In Progress")

Can't seem to get the syntax right

Jeff Reisman

The COUNTIFS function counts if all the criteria evaluate to true. You don't need the AND function here. But you do need to have criteria range and criteria separated by commas. Try this:

=COUNTIFS({Master Project List Range 1}, > TODAY(-8), {Master Project List Range 2}, "In Progress")

Jeff Reisman

The COUNTIFS function counts if all the criteria evaluate to true. You don't need the AND function here. But you do need to have criteria range and criteria separated by commas. Try this:

=COUNTIFS({Master Project List Range 1}, > TODAY(-8), {Master Project List Range 2}, "In Progress")