| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
=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 |
|
#4
|
|||
|
|||
|
|
|
#5
|
|||
|
|||
|
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
| Finding Median if a value = 1.. help! | Excel Worksheet Functions | |||
| showing percentages in pie charts | Charts and Charting in Excel | |||
| Calculating Percentages with Variables | Excel Worksheet Functions | |||
| How can i imput a formula in excel for finding the area of a regu. | Excel Discussion (Misc queries) | |||
Linear Mode
