Mean, median and mode

Works like a charm! Thanks a million!

OK, so it worked REALLY well but of course a twist is now thrown into the mix.

Suppose my numbers are in column L. If the report is marked as unsigned it will have a U in column K and L will read as -38,000 or other very high number. This number skews my data.

Is there a if/then statement I can add to the =AVERAGE to say if column K = U then do not add this data into the average?

Thanks

You can use an "array formula" like this

=IF(K2:K100<>"U",IF(L2:L100,L2:L100)))

needs to be confirmed with CTRL+SHIFT+ENTER

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!