Percent Within Target

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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
 
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
Click to expand...

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

Format as Percentage.
 
Back
Top