That doesn't seem to be doing the trick. In line 46808 I put this in:

=IF(M2:M46807<>"U",IF(N2:N46807,N2:N46807))

N is the column with the number of days. Column M has the status (signed, unsigned, incomplete). I just want the signed documents to be averaged. I guess I could sort them by letter and just do the math but automation would be a lot more cool

Thanks!