Percent Within Target   

I need help creating a formula that will calculate the percentage of values 
that are <= 14 (days).
Sample data:
29,34,96,15,14,14,13,13,13,13,13,13,12,12,11,11,10,9,9

Thank you.
Christine

date: Fri, 4 Jul 2008 06:30:01 -0700   author:   Chris

Re: Percent Within Target   

On Jul 4, 6:30 am, Chris  wrote:
> I need help creating a formula that will calculate
> the percentage of values that are <= 14 (days).
> Sample data:
> 29,34,96,15,14,14,13,13,13,13,13,13,12,12,11,11,10,9,9

=countif(A1:A20,"<=14") / count(A1:A20)

Format as Percentage.

date: Fri, 4 Jul 2008 06:43:13 -0700 (PDT)   author:   joeu2004