Finding Percentages
 

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

=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

=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

Thanks it worked great.

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

Thank You

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