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

[µo°Ý] ½Ð±Ð¤½¦¡Â²¤Æ

[µo°Ý] ½Ð±Ð¤½¦¡Â²¤Æ

¥H¤U¤½¦¡¬O§Úªº²Â²Â»s§@¡A½Ð±Ð¦Ñ®v©M¦P¾Ç­Ì¯àÀ°¦£Â²¤Æ¥¦¶Ü¡H

=IF($BP$57=1,$DH96,0)+IF($BP$59=1,$DI96,0)+IF($BP$61=1,$DJ96,0)+IF($BP$63=1,$DK96,0)+IF($BP$65=1,$DL96,0)+IF($BP$67=1,$DM96,0)+IF($BP$69=1,$DN96,0)+IF($BP$71=1,$DO96,0)+IF($BP$73=1,$DP96,0)+IF($BP$75=1,$DQ96,0)+IF($BP$77=1,$DR96,0)+IF($BP$79=1,$DS96,0)

ÁÂÁÂ

=SUMPRODUCT((SUBTOTAL(9,(OFFSET($BP$57,(ROW(A1:A12)-1)*2,)))=1)*TRANSPOSE(DH96:DS96))
°}¦C¤½¦¡

TOP

´¶³q¤½¦¡

=MMULT(--(DH96:DS96),--(N(OFFSET(BP57,(ROW(1:12)-1)*2,))=1))

TOP

ÁÂÁ¦h¦ì¦Ñ®v¦b³o­Ó»s§@¤WÀ°§U¡A¤w¯à§âÄæ¦C¦ì¸mÀH·N§ï°Ê¤Î¾ã½d³ò¦V¤U½Æ»s¤§¥Î³~¡C

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD