Here is exactly what you asked for, but give this some thought to make sure it's really what you need for your purposes:
Formula:
=COUNTIFS(Table1[DD],"<>",Table1[STOP],"<>",Table1[DD],"<"&Table1[STOP])/COUNT(Table1[STOP])
The way you wrote this it sounds like you want:
The count of rows where DD and STOP are both non-blank AND DD < STOP
divided by
The count of rows where STOP is non-blank.
However, the count of rows where STOP is non-blank includes rows where DD is blank, which are not included in the top number. Are you sure that is really the calculation you need?
Bookmarks