¨Ì¤£¦P«~¶µ¤Î©m¦W§ì¨ú¼Æ¶q

shan0948

½Ð°Ý¦U¦ì¥ý¶i¡A¤p§Ì¦³¤@ªí³æ»Ý¨Ì¾Ú¤£¦Pªº«~¶µ¤Î©m¦W¡A§ì¨ú¥tªí¹ïÀ³Àx¦s®æ¡A¤½¦¡¨ç¼Æ­n¦p¦ó³]©w¡A¸Ô¦pªþÀɤº»¡©ú¡AÁÂÁ«ü¾É¡I ¨Ì¤£¦P«~¶µ¤Î©m¦W§ì¨ú¼Æ¶q.rar (13.99 KB)

¤U¸ü¦¸¼Æ: 16

2021-8-18 15:02

shan0948

¦^´_ 6# ML089


    M ¤j¦n¡AÁÂÁ«ü±Ð¡Aª½±µ½Æ»s¹L¥hªº½T¬Ù¨Æ¡I

ML089

¦^´_ 5# shan0948
¸É¥R
¤½¦¡½Æ»s»Ý­n ¿ï C3:D3 2®æ ¥kÁä½Æ»s
¦A¿ï¨ä¥¦®æ¶K¤W

¹j¾ÀÄ檽±µ¶K¤W¡A¤£¥Î­×§ï¤½¦¡

shan0948

¦^´_ 3# ML089


    M ¤j¦n¡A·PÁ«ü¾É¡A¸g¹L´ú¸Õ¨Ï¥Î§¹¥þ²Å¦X¬d¸ß»Ý¨D¡A¬Æ¦Ü¤ñ¤p§Ì¦Û³]ªº¬d¸ß¤½¦¡ÁÙ­n²¼ä¡A¨ü±Ð¤F¡AÁÂÁ¡I

shan0948

¦^´_ 2# hcm19522


    h ¤j¦n¡A·PÁ±zªº«ü¾É¡A¸g¹L´ú¸Õ¨Ï¥Î§¹¥þ¹F¨ì»Ý¨D¡A¦Ó¥B³s±aÅã¥Üª÷ÃB¡A¬Ù®É¬Ù¨Æ«Ü¦h¡AÁÂÁ¡I

ML089

²Î­p¬Ý¼Ó¤W

¬d¸ß¥i¥H¥Î
C3:D3 =VLOOKUP(B3,Sheet1!$B:$M,MATCH($F$1,Sheet1!$B$2:$M$2,)+{0,1},)

½Æ»s¤½¦¡¡A¿ï¾Ü C3:D3 Àx¦s®æ2®æ¡A½s¿è¦C¶K¤W¤½¦¡¡A¤TÁä¿é¤J¤½¦¡(¥ý«öCTRL+SHIFT¤£©ñ¡A¦b«öENTER¿é¤J¤½¦¡

hcm19522

C3:D3 ¤U©Ô {=SUM(IFERROR((Sheet1!$C$2:$K$2=$F$1)*(Sheet1!$B$4:$B$57=$B3)*Sheet1!C$4:K$57,))

G3:H3 ¤U©Ô {=SUM(IFERROR((Sheet1!$C$2:$K$2=$F$1)*(Sheet1!$B$4:$B$57=$F3)*Sheet1!C$4:K$57,))

https://blog.xuite.net/hcm19522/twblog/589962106