Calculatinng Percentages

[agnerc]

I need some help calculating percentages.

I have 30 rows, each row may hve a 1 or 0. I would like to calculate the percentage of 1's out of the 30 rows.

I am essentially using this as an on time delivery.

I get the 1 and 0 by comparing dates, if my start date is greater than my finish date then it get s 1, else a 0.

Thank you,

 

[JoeMo]

One way (assuming your 1's and 0's are in A1:A30):

=SUM(A1:A30)/COUNT(A1:A30)

format the cell holding this formula as percentage

 

[alansidman]

Assume your 1s and 0's are in column A, then in A31 =COUNTIF($A$1:$A$30,1)/30