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

[µo°Ý] SUMPRODUCT­pºâ§tªÅ¥Õªº­È¦s®æ

[µo°Ý] SUMPRODUCT­pºâ§tªÅ¥Õªº­È¦s®æ

Dear,
AÄæ®Æ¸¹¤£­«½Æ
B:Gªº¤é´Á·|¦³­«½Æ©Ê,¤]·|¦³ªÅ¥Õ®æ
¦p¦óÅýB1:G1=R1®É
±a¥X¬Û¹ïÀ³Ä檺¤é´Á?
R2=SUMPRODUCT(($B$1:$G$1=$R$1)*($A$2:$A$21=$A2)*($B$2:$G$21))
¥X²{#VALUE! µLªk­pºâªÅ¥ÕÄæ

·íRÄ檺¤é´Á¥X²{®É
UÄæ¥[Á`¤p©óRÄæ¤é´ÁªºH:Mªº­È
VÄæ¥[Á`>=RÄæ¤é´ÁªºH:Mªº­È
¦ýRÄæªÅ¥Õ®É,¼Æ­È­n¬°0

SUMPRODUCT_­pºâ§tªÅ¥Õªº­È¦s®æ.rar (10.13 KB)

¦^´_ 2# ML089

·PÁÂ...

TOP

¦^´_ 1# PJChen


    =IFERROR(1/(1/SUMPRODUCT(($B$1:$G$1=$R$1)*($A$2:$A$21=$A2),($B$2:$G$21))),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD