ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ­n¦p¦ó°µ¥X¯x°}¬Û°£¡H

[µo°Ý] ­n¦p¦ó°µ¥X¯x°}¬Û°£¡H


§Ú¦³¤@µ§¸ê®ÆªºÃþ«¬¦p¹Ï
§Ú·Q­n°µªº¹Bºâ¬°¡uB©±°â»ù/A©±°â»ù*100¡v¤Î¡uB©±«P¾P»ù/A©±«P¾P»ù*100¡vªº¥[Á`
B©±¦³A©±°â»ù³£»Ý¦³­È¤~¯à¬Û°£¡A­Y¨ä¤¤¤@¶¡©±¨S¦³­È´N¤£¯à¬Û°£¡A¦p¬°«P¾P»ù¥ç¦P
¤@¶}©lªº·Qªk¬O·Q­n¥Î¯x°}¤U¥h°µ¡A¦ý¬O¹J¨ì¤F¨â­Ó¯x°}­n¬Û°£§Ú´N¤£·|¤F
¤£¾å±o³o¼Ë­n«ç»ò±N¤½¦¡¼g¥X¨Ó
¨ä¹ê¤]¤£¤@©w­n¥Î¯x°}ªº¤èªk¤U¥h°µ¡A¥u­n¥i¥H°µ±o¥X¨Ó§Ú·Q­nªº¼Æ¾Ú§Y¥i
q.rar (7.64 KB)

=SUM(IF((B3:B66<>"")*(D3:D66<>""),D3:D66/B3:B66))*100
°}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2012-12-22 18:02 ½s¿è

=SUM(IF((B3:B66<>""),D3:D66/B3:B66))*100
°}¦C¤½¦¡
¥k©Ô½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥i¥Hª½±µ¥Î{=A1:C3/D1:F3}
¦V°ª¤â学习

TOP

¦pªG¥i¥H¦³¤¤间¨B骤ªº话¡A¥i¥H¨Ï¥ÎMINVERSE¨ç数±o¨ì°f¯x阵
µM¦Z¥ÎMMULT°µ¯x阵©M°f¯x阵ªº­¼ªk
¦V°ª¤â学习

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD