COUNTIFS with an OR in it

Ulrich Anderhub 1

Hi Community!

I am struggling with the below COUNTIFS formula which basically has to have an OR logic in it...

=IF(Date@row <= TODAY(), COUNTIFS(OR({Status 1}, "Complete", {Status 11}, "N/A"), {Planned End Date 1}, <=Date@row, {Parent Child 1}, "Child"), "")

There must be a syntax error, but I can't find it. Any hints or tips would be great!

Paul Newcome

Can you describe the expected logic?