End date is in the past

Billymacdo

this runs
=COUNTIFS({Group}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, <>"Complete", {Campaigns Range 1}, <>"deferred")

this doesn't
=COUNTIFS({Group}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, <>"Complete", {Campaigns Range 1}, <>"deferred", {End Date} < TODAY())

{End Date} is just a column with a date

Mark.poole

@Billymacdo

You forgot the comma for the end date part.

=COUNTIFS({Group}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, <>"Complete", {Campaigns Range 1}, <>"deferred", {End Date}, < TODAY())