|
||
0
0
ÆÄ»êÀÇÁö¸§±æ»Ë»Ñ
¾ç½ÄÁ» ¿Ã·ÁÁÖ¼¼¿ä
2015-03-26
|
0
0
¿ë¿ë
µµ¿òÀÌ µÇ½Ã·Á³ª¿ä...?
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) |
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | -¸ñ·Ïº¸±â-±Û¾²±â |