Trying to say "and this column isnt blank"

Billymacdo

=COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, "Not Started", NOT(ISBLANK({Group})))

:( wont work

Julie Fortney

HI @Billymacdo

Try this:

=COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, "Not Started", {Group},NOT(ISBLANK(@cell)))

COUNTIFS formulas look for the range, then the criterion to evaluate that range for. (Range 1, Criterion 1, Range 2, Criterion 2, Range 3, Criterion 3…)

Julie Fortney

HI @Billymacdo

Try this:

=COUNTIFS({Campaigns Status Count Range}, HAS(@cell, [Primary Column]@row), {Campaigns Range 1}, "Not Started", {Group},NOT(ISBLANK(@cell)))

COUNTIFS formulas look for the range, then the criterion to evaluate that range for. (Range 1, Criterion 1, Range 2, Criterion 2, Range 3, Criterion 3…)