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

"Justina Call via OfficeKB.com" wrote:

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