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

and format as a percentage

--

HTH

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


"Justina Call via OfficeKB.com" wrote in message
...
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.

--
Message posted via http://www.officekb.com