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

¦h±ø¥ó­pºâ­È (§t¤é´Á½d³ò¤º©Ò¥ðªº®É¼Æ­È)

¦h±ø¥ó­pºâ­È (§t¤é´Á½d³ò¤º©Ò¥ðªº®É¼Æ­È)

¤j¤j °ª¤â­Ì¦n

     ½Ð±Ð¤@¤U¦pªG¦A¤£¦n¼{¨Ï¥Î °}¦C,¬O§_¦³¨ä¥L¤½¦¡¥i­pºâ¥X­û¤u¦U¤ë¥÷©Ò¥ðªº®É¼Æ    ¨Ò¦p: SUMIFS©ÎSUMPRODUCT,
   ¦]¬°§Úı±o°}¦C·|§Ñ°O«öctrl+shift +enter,¨D¨ó§U  ÁÂÁÂ
ps:¦]¦³¯S¥ð°_©l¥H¤ÎºI¤î¤é°ÝÃD,,½Ð°ª¤â­Ì¨ó§U  ÁÂÁÂ
20180807.zip (16.23 KB)
yvonne

¦^´_ 4# ­ã´£³¡ªL

·PÁ·Ǥj
     ¥i¥H­pºâ «D±`·PÁÂ*100000
yvonne

TOP

=SUMPRODUCT((¤u§@ªí3!$B$2:$B$300=$B2)*(¤u§@ªí3!$C$2:$C$300>=$R2)*(¤u§@ªí3!$C$2:$C$300<=$S2)*(¤u§@ªí3!$E$2:$E$300=D$1),¤u§@ªí3!$H$2:$H$300)

TOP

¦^´_ 2# rouber590324

·PÁÂR¤j¦^´_,¦]¬°¦³¤é´Áªº°_¨´½d³ò,
    ¦]¬°AAAªº¯S¥ð°²¬O2017/07/10~2018/07/11 ¶W¹L¤é´Á2018/7/11¤£¯à¯Ç¤J­pºâ
yvonne

TOP

¸Õ¸Õ
=SUMPRODUCT((¤u§@ªí3!E2:E65536=P1)*(¤u§@ªí3!B2:B65536=B2)*(¤u§@ªí3!G2:G65536="¯S¥ð°²"),¤u§@ªí3!I2:I65536)
ù

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD