I need to count the number of times the "Status" column = "Assigned to SCJ" and
the number of times a date appears in "NDA Signed" column in the same row.
Both criteria need to be met.
The "Status column is a drop down list.
The "NDA Signed" column is a date.
In the parent row, I added this calculation but it is not working. I'm sure it's wrong :-(
Can someone please help?
=COUNTIFS(CHILDREN(Status7), "Assigned to SCJ", [2016-NDA Signed (mm/dd/yy)]7), "1"
