- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 255
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-24
|
¦^´_ 4# aer
¬Ý¨ìx©w¸q¦WºÙ¤½¦¡
Y§@¥Î¤¤Àx¦s®æ¦¡²Ä15¦C¡A¨ä¤¤
LOOKUP(9.9E+307,$A$1:$A15)
·|§ä¨ì15¦C©¹¤W³Ì¥ý§ä¨ìªº¼ÆÈ
¤]´N§ä¨ì¦X¨ÖÀx¦s®æ²Ä¤@Ó¦ì¸mªºÈ
¦ÓDÄ檺¤½¦¡¤º
LOOKUP("ùÕ",OFFSET($B$1,,,,MATCH($B15,$B$2:$Q$2,0)))
MATCH($B15,$B$2:$Q$2,0)³o¼Ë·|¦b²Ä2¦C§ä¨ì¦a°Ï¦WºÙªº¦ì¸m
OFFSET($B$1,,,,MATCH($B15,$B$2:$Q$2,0))´N·|±qB1¶}©lÂX®i¦¨MATCH($B15,$B$2:$Q$2,0)ªº½d³ò°µLOOKUPªº·j´M½d³ò
LOOKUP("ùÕ",OFFSET($B$1,,,,MATCH($B15,$B$2:$Q$2,0)))
´N¦b¸Ó½d³ò¤º§ä¨ì³Ì«áªº¤å¦r¡A´N±o¨ì°Ï°ì§O
¦b¦¹§ó¥¿ªþ¥ó¤ºD15ªº¤½¦¡
=(MATCH(B15,$B$2:$Q$2,0)>13)*(MAX(0,(C15-3))*1500+5000)+(MATCH(B15,$B$2:$Q$2,0)<13)*(INDEX($B$3:$Q$12,SUMIF(x,LOOKUP("ùÕ",OFFSET($B$1,,,,MATCH($B15,$B$2:$Q$2,0))),$C$15:$C$65536),MATCH(LOOKUP("ùÕ",OFFSET($B$1,,,,MATCH($B15,$B$2:$Q$2,0))),$B$1:$Q$1,0)))
§âpºâCÄæ½d³òÂX¥R¨ì¤u§@ªíÁ`¦C¼Æ |
|