问题描述
您好，我正在努力开发一个公式，以帮助区分工作角色和已完成的培训，以符合我们公司的要求。即管理员不需要经理需要完成急救。
hello, im trying to develop a formula tha will assist in distinguishing job roles to the training that has been completed to align with our company requirements. i.e a manager is required to complete first aid where as a admin is not.
我目前运行以下公式以确定培训完成情况
im currently running the below formula to determine completion of training
= IF（AM60 =""，" INCOMPLETE" ;，IF（DATE（YEAR（AM60），月（AM60），日（AM60））≤; DATE（YEAR（TODAY（）） - 1，MONTH（TODAY（）），日（TODAY（））），QUOT ;必需的"，"CURRENT"））
=IF(AM60="","INCOMPLETE",IF(DATE(YEAR(AM60),MONTH(AM60),DAY(AM60))<DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),"REQUIRED","CURRENT"))
并使用以下内容来区分完成百分比
and im using the below to distinguish the completion percentage
= COUNTIF（G4：G7，"INCOMPLETE"）/ COUNTA（G4：G7）
=COUNTIF(G4:G7,"INCOMPLETE")/COUNTA(G4:G7)
= COUNTIF（G4：G7，& ; CURRENT"）/ COUNTA（G4：G7）
=COUNTIF(G4:G7,"CURRENT")/COUNTA(G4:G7)
= COUNTIF（G4：G7，"REQUIRED"）/ COUNTA（G4：G7）
=COUNTIF(G4:G7,"REQUIRED")/COUNTA(G4:G7)
我目前正在按标签分隔作业并运行这些公式，但我想知道是否有办法可以在collumn c和运行公式中选取作业标题获取有多少经理已完成急救等.....并以总百分比形成这个
。
im currently seperating the jobs by tabs and running these formulas but i want to know if there is a way i can pick up the job title in collumn c and running formulas to pick up how many mangers have completed first aid ect..... and generating this as a percentage total.
请帮助
推荐答案
= COUNTIFS（range_in_G，" INCOMPLETE"，" range_in_C，" ;经理"）
=COUNTIFS(range_in_G, "INCOMPLETE", "range_in_C, "Manager")
和其他人类似。
这篇关于按工作角色完成的百分比的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！