ªð¦^¦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)

¦^´_ 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

¦^´_ 2# ML089

·PÁÂ...

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD