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

[µo°Ý] ¦çªA¤Ø¤o¼Æ¶q²Î­p

[µo°Ý] ¦çªA¤Ø¤o¼Æ¶q²Î­p

¦U¦ì¥ý¶i§Ú¥i¯à¦³1¡B2¤dµ§¦çªA¤Ø¤o»Ý­n²Î­p,¥i¥Î¨ç¼Æ¤À¶}­pºâ¨k¡B¤k¦U¤Ø¤o¤§¤H¼Æ¶Ü?

¦çªA¤Ø¤o²Î­p.rar (9.33 KB)

¦^´_ 1# wenwu748
1.½Ð©óO2Àx¦s®æ¶K¤W
=SUM(IF($D:$D=$M2,IF($E:$E=O$1,1,0)))
2.«ö CTRL+SHIFT+ENTER Áä(°}¦C¤½¦¡ªk)¡A±N¤½¦¡¿é¤J±zªº¬¡­¶Ã¯¡C
3.¦A¥HO2Àx¦s®æ¬°½d¥»¡A¦VUÄæ¦V²Ä3¦C½Æ»s§Y¥i¡C

TOP

·PÁÂP212ªº«ü¾É­ì¨ÓEXCEL¤]¥i¥H³o¼Ë¨Ï¥Î

TOP

¦^´_ 1# wenwu748
O2=SUMPRODUCT(($A$2:$A$17=$K2)*($E$2:$E$17=O$1)*($D$2:$D$17=$M2))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsieh¶W¯Åª©¥Dªº«ü¾É³o¼Ë¤l¤]«Ü¦n¥Î

TOP

¦pªG¤½¦¡­n¾A¦X¨k¸ò¤k¥Î,­É¥Î¶W¯Åª©¥D¤½¦¡¤p¤p­×§ï
O2

SUMPRODUCT(($A$2:$A$17=LOOKUP("々",$K$2:$K2))*($E$2:$E$17=O$1)*($D$2:$D$17=$M2))

TOP

·PÁ«ü¾É¡A½Ð°ÝZZ5151353ª©¥D"々"¥Nªí¤°»ò·N«ä?

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD