Finding Percentages

[Justina Call via OfficeKB.com]

I track individuals training and I have to find a percentage formula that
will add up how many people in a colum (of dates) who have completed there
training, the ones who have completed trainng have a date in the cell the
ones who havn't have $VALUE! in the cell. Please help.

 

[Bob Phillips]

=COUNTIF(B:B,"<>$VALUE!")/COUNTA(A:A)

and format as a percentage

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Duke Carey]

=COUNTIF(A1:A2,"<>#Value!")/(COUNTIF(A1:A2,"<>#Value!")+COUNTIF(A1:A2,"=#Value!"))

 

[Justina Call via OfficeKB.com]

Thanks it worked great.

 

[Justina Call via OfficeKB.com]

Thank You