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

[µo°Ý] ½Ð°Ý¦p¦ó¥[Á`ªí¤¤«ü©w¤é´Á(©Î´Á¶¡)

¦^´_ 2# Hsieh

¦¹¦¡§ï¬°

=SUMPRODUCT(--(YEAR(A14:A23)=F24),H14:H23)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# 97forum
H24°}¦C¤½¦¡
=SUMPRODUCT((IF(ISNUMBER(INDIRECT("R2C1:R[-1]C1",0)),YEAR(INDIRECT("R2C1:R[-1]C1",0)),0)=F24)*INDIRECT("R2C:R[-1]C",0))
´ú¸ÕÃD.rar (8.05 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
ÁÂÁÂ¥ý¶iªº«ü¾É¡A¥t¥~·Q½Ð±Ð¤@­Ó°ÝÃD¡A¦pªGµ¹¤©ªº½d³ò¤¤¦³µL¼Æ­È(©ÎªÅ¥Õ)¡A´NµLªk¦¨¥ß¬O³o¼Ë¶Ü¡H
©Ò¥H¦pªG¦³·s¼Æ­È¥[¤JªÅ¥ÕÀx¦s®æ®É¥²¶·¦A¥h­×§ï¤½¦¡ªº½d³ò­È©ÎªÌ¬O¥i¥H§ï¨ä¥L¤è¦¡¡H

TOP

¦^´_ 1# 97forum


    =SUMPRODUCT((YEAR(A14:A23)=F24)*H14:H23)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD