|
||
![]() |
![]() ![]() ![]()
¾ç½ÄÁ» ¿Ã·ÁÁÖ¼¼¿ä
2015-03-26
![]()
|
![]() |
![]() ![]()
µµ¿òÀÌ µÇ½Ã·Á³ª¿ä...?
1. =COUNTIF($D$9:$D$137,">0") 2. =COUNTIFS($D$9:$D$137,">0",$G$9:$G$137,"o") 3. =COUNTIFS($D$9:$D$137,">0",$G$9:$G$137,"<>o") 4. =COUNTIFS($D$9:$D$137,">0",$E$9:$E$137,">0") 5. =COUNTIFS($D$9:$D$137,">=10",$E$9:$E$137,0) 6. =C2/SUM($C$2:$C$6) =C3/SUM($C$2:$C$6) =C4/SUM($C$2:$C$6) =C5/SUM($C$2:$C$6) =C6/SUM($C$2:$C$6) |
|
|
![]() |
![]() | ¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | -¸ñ·Ïº¸±â-±Û¾²±â | ![]() |