- ©«¤l
 - 4901 
 - ¥DÃD
 - 44 
 - ºëµØ
 - 24 
 - ¿n¤À
 - 4916 
 - ÂI¦W
 - 270  
 - §@·~¨t²Î
 - Windows 7 
 - ³nÅ骩¥»
 - Office 20xx 
 - ¾\ŪÅv
 - 150 
 - ©Ê§O
 - ¨k 
 - ¨Ó¦Û
 - ¥x¥_ 
 - µù¥U®É¶¡
 - 2010-4-30 
 - ³Ì«áµn¿ý
 - 2025-11-4 
 
                  
 | 
                
¦^´_ 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¼Æ |   
 
 
 
 |