COUNTIF calculation when a condition is met

Gaurav Chauhan

=COUNTIFS((Status@row,"DocuSign Approved"[Actual Completion]@row-[Target Completion]@row})

This is throwing an error. How do I calculate the Net work days between Actual Completion Date column and Target Completion Date column for only when the Status of the case is DocuSign Approved

Please help

Kimberly Loveless

=IF(Status@row = "DocuSign Approved", NETWORKDAYS([Actual Completion]@row,[Target Completetion]@row))

Kimberly Loveless

It looks like you have some extra characters in some places and missing a comma as well which could cause the errors as well, but I think it is also the wrong type of formula for what you are looking to do if I understood correctly