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

[µo°Ý] IF ±ø¥ó§PÂ_°ÝÃD

¦^´_ 1# john2006168

½Ð¸Õ¬Ý¬Ý¡AÁÂÁ¡C

F3 = IF(COUNTIF(E2:E3,E3)=1,SUMPRODUCT(($B$3:$B$8=$B3)*1,($E$3:$E$8=$E3)*1,$D$3:$D$8),"")

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD