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

[µo°Ý] °Ï¶¡¥[Á`¨ç¼Æ

¥»©«³Ì«á¥Ñ ML089 ©ó 2019-4-28 07:53 ½s¿è

¦^´_ 4# PJChen


    ¥X³f²Î­p
B2 =SUMPRODUCT(($A2=¥X³f!$A$2:$A$9)*($B2=¥X³f!$B$2:$B$9)*ISNUMBER(FIND(C$1,¥X³f!$C$1:$R$1))*¥X³f!$C$2:$R$9)
¤U©Ô¥k©Ô

©Î¬O

B2 =SUMPRODUCT(SUMIFS(OFFSET(¥X³f!$C:$C,,COLUMN($C:$R)-3),¥X³f!$A:$A,$A2,¥X³f!$B:$B,$B2)*ISNUMBER(FIND(C$1,¥X³f!$C$1:$R$1)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# PJChen

¸ó¤u§@ï®É¡A»Ý­nÀɮצWºÙ¤Î¸ô®|
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD