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

[µo°Ý] ¤£¦PÄ楼¥[Á`

[µo°Ý] ¤£¦PÄ楼¥[Á`

¦U¦ì¦n..
2019-03-25_16-01-39.jpg
2019-3-25 16:05

¦p¤W¹Ï..¦pªGb12­n¥[Á`ÄÝ©ó¥x¥_¥«ªº4-8¤ë ©Î¬O1-6¤ë
²M°Ý¨ç¼Æ¸Ó¬O¥Î­þ­Ó..¦]¬°Äæ©M¦C³£¦³±ø¥ó..§Ú¥Î sumproduct µLªk¬Û¥[©Ò»Ý½d³òªº¸ê®Æ

³Â·Ð¦U¦ì¥ý¶i¤F...

²Ä¤@¦C¤é´Á¬O¬Æ»ò®æ¦¡
¤å¦r '2015/01
¼Æ¦r 201501 (®æ¦¡¤Æ 2015/01)
¤é´Á  2015/1/1

¦³Àɮפj®a¤ñ¸û¦³®É¶¡¦^ÂÐ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ hungrn ©ó 2019-3-26 16:45 ½s¿è

test.rar (8.87 KB)

¦U¦ì¥ý¶i¦n...¦pªþ¥ó..
«á¨Ó§Ú¥Îmatch©Maddress ¼g¥X¨Ó¤F..¦ý­n¬Û¥[ªº¸Ü¤½¦¡·|¹Lªø
¤£ª¾¥i§_¦³¤ñ¸û²³æªº¤è¦¡?

ÁÂÁ¦U¦ì

TOP

=SUMPRODUCT(OFFSET(A$1,MATCH(A12,A:A,)-1,MATCH(B$11,$1:$1,)-1,,SUMPRODUCT(MATCH(B$11:C$11,$1:$1)*{-1,1})+1))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=SUMPRODUCT((B$1:R$1>=B$11)*(B$1:R$1<=C$11)*(A$3:A$9=A12)*B$3:R$9)

TOP

=SUMPRODUCT((B$1:R$1>=B$11)*(B$1:R$1<=C$11),B3:R3)
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ´X¦ìªº«ü¾É..¹yµM¤F¸Ñ¤F

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD