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

[µo°Ý] SUMPRODUCT_§t¤å¦r¥[Á`

[µo°Ý] SUMPRODUCT_§t¤å¦r¥[Á`

½Ð°Ý¤j¤j,

J2=SUMPRODUCT(($E$1:$I$1="¤p­p")*($A$2:$A$9=$A2)*($E$2:$I$9))
¦]¬°FÄ榳¤å¦r,¨ÏJÄæ¥X²{#VALUE!ªº¿ù»~,¥i¥H¥[¤J¤°»ò¨ç¼Æ¨ÏSUMPRODUCTªº¥[Á`¥¿½T?




SUMPRODUCT_§t¤å¦r¥[Á`.rar (8.57 KB)

=SUMPRODUCT((E$1:I$1="¤p­p")*(A$2:A$9=$A2),E$2:I$9)  "*"§ï¦¨³r¸¹, ¥i²¤¹L¤å¦r

­Y"®Æ¸¹"¤£­«ÂÐ, ¥i¥Î:
=SUMIF(A$1:J$1,"¤p­p",A2:J2)

TOP

¦^´_ 2# ­ã´£³¡ªL

½Ð°Ý­ã¤j,

§Ú¦³Ãþ¦üªº¥t¤@ºØ¥[Á`¤è¦¡ "XX¤p­p"¡AXX·|¦³¦UºØ¤£¦Pªº´y­z,·Q¦P¼Ë®M¥ÎSUMPRODUCT³oºØªº¤èªk,½Ð°Ý­n¦p¦ó²¤¹LXX,¥u¨ú"¤p­p"ªº¤å¦r¥h¥[Á`?

=SUMPRODUCT((E$1:I$1="¤p­p")*(A$2:A$9=$A2),E$2:I$9)

TOP

¦^´_ 3# PJChen


=SUMPRODUCT((right(E$1:I$1,2)="¤p­p")*(A$2:A$9=$A2),E$2:I$9)

TOP

¦^´_ 4# ­ã´£³¡ªL
­ì¨Ó¥i¥H¥u¨ú¥k2
¤§«e¦bºô¸ô¤W¬Ý¨ì¦³¥t¤@ºØ¤èªk¥[¤W"--"
¦ý§Ú«ç»ò¸Õ³£¤£¦æ~~

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD