按工作角色完成的百分比 [英] percentage of completion by job role

问题描述

您好，我正在努力开发一个公式，以帮助区分工作角色和已完成的培训，以符合我们公司的要求。即管理员不需要经理需要完成急救。

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.  

请帮助

推荐答案

也许这样的公式可以计算未完成的经理

Perhaps a formula like this to count managers who haven't completed

= COUNTIFS（range_in_G，" INCOMPLETE"，" range_in_C，" ;经理"）

=COUNTIFS(range_in_G, "INCOMPLETE", "range_in_C, "Manager")

和其他人类似。

这篇关于按工作角色完成的百分比的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！