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

SUMPRODUCT ¹J¨ìªÅ¥ÕÀx¦s®æÅã¥Ü¿ù»~¸Ñ¨M¤èªk

SUMPRODUCT ¹J¨ìªÅ¥ÕÀx¦s®æÅã¥Ü¿ù»~¸Ñ¨M¤èªk

·Q½Ð±Ð =SUMPRODUCT(F18:F28*G18:G28)  ¬O§Ú²{¦b³]©wªº¨ç¼Æ¡A

¦pªG§Ú§R°£¤F   ¦C F28¡AG27ªº¼Æ¾Ú«á¡A¥L´N·|Åã¥Ü¿ù»~°T®§¡A³o¥i¥H«ç»ò¸Ñ¨M¶Ü¡H §Ú¬ã¨s¦n¤[..  ¤£ª¾¹D¸Ó«ç»ò³]¨ç¼Æ¡C

·Q½Ð±Ð =SUMPRODUCT(F18:F28*G18:G28)  ¬O§Ú²{¦b³]©wªº¨ç¼Æ¡A
¦pªG§Ú§R°£¤F   ¦C F28¡AG27ªº¼Æ¾Ú«á¡A¥L´N ...
alivewmc µoªí©ó 2014-11-2 16:51

¤@¯ë³B²z§R°£Àx¦s®æ¾É­Pµo¥Í¤½¦¡¿ù»~°T®§ªº¤è¦¡,
¬O±N³B²z½d³ò©w¸q¦WºÙ,
¤½¦¡¸Ì«h¹ï¦WºÙ°µ¬ÛÃö­pºâ.

TOP

¦^´_ 2# luhpro


    §Ú¸ÕµÛ©w¸q¦WºÙ«á­pºâ¡A¦ý¤´¬O¿ù»~°T®§... ´ú¸Õª© (1).rar (10.62 KB)

¦³°ª¤â¥i¥HÀ°§U§Ú¶Ü.. ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-11-4 09:59 ½s¿è

¦^´_ 3# alivewmc
´N3#ªþÀɤ¤­ì¦³ªº¦WºÙ©w¸q«Øij­×§ï¦p¤U¡G
©w¸q¦WºÙ¡u³æ»ù1¡v°Ñ·Ó¨ì
=OFFSET(­pºâªí!$K$3,,,COUNT(­pºâªí!$K:$K))
©w¸q¦WºÙ¡u¼Æ¶q1¡v°Ñ·Ó¨ì
=OFFSET(­pºâªí!$L$3,,,COUNT(­pºâªí!$L:$L))
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 3# alivewmc

=SUMPRODUCT(³æ»ù1*¼Æ¶q1)
§ï¬°
=SUMPRODUCT(³æ»ù1,¼Æ¶q1)

´N¬O±N * §ï¬° ,
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁ¤j®a!! §Ú·|¤F!!! ·PÁÂ

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD