Get Minimum Time Where Criteria May Be In Two Different Columns

[wsnyder]

Hi,

Using Office 365.

I am trying to determine the minimum time an event occurred in the Work Breakdown Structure (WBS)
The problem seem to be that the the event may exist in either Col V or Col W as the event updates from Old to New Value, some events may repeat.

Any other thoughts how I can I accomplish to get the entire path of 13 different events using a combination of MINIFS() and MAXIFS().
Here is my current MINIFS formula returning a #VALUE ! error.

=MINIFS('WBS Data'!$X$2:$X$19667,'WBS Data'!$V$2:$W$19667,"="&C$2,'WBS Data'!$A$2:$A$19667,"="&$B3)

Thanks,
-lou