Impossible to countifs on an empty column

Pierre-Eric Collette

Hello,

i have this formula that works fine :

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0"))

However when I add this last condition :

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0"), {TgtDate}, "")

I get « INCORRECT ARGUMENT SET » error.

The TgtDate column is mostly empty so it should work I think. But it doesn’t.

thanks for your ideas to troubleshoot this !

best,

Pierre-Eric

Pierre-Eric Collette

Thanks Carson... i must have been tired on this one.

Appreciate the fresh pair of eyes

Best,

Pierre-Eric

Carson Penticuff

Try tucking the last condition inside the COUNTIFS closing paren.

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0", {TgtDate}, ""))

Pierre-Eric Collette

Thanks Carson... i must have been tired on this one.

Appreciate the fresh pair of eyes

Best,

Pierre-Eric