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

[µo°Ý] µ§¼Æ¤£¦P¡A¦p¦ó¥[Á`¡H

[µo°Ý] µ§¼Æ¤£¦P¡A¦p¦ó¥[Á`¡H

¤j®a¦n¡G
½Ð°Ý¦pªG¨C¦¸¦bsheet1ªº¸ê®Æµ§¼Æ³£¤£¦P¡A¥Hªþ¥ó¬°¨Ò¡A³o¦¸¬O30µ§¡A¤U¦¸¥i¯à»Ý­n¶K¹L¨Ó50µ§¡A
¨º¦p¦ó¦bsheet2!B2:H2¼g¤½¦¡©O¡C
§Ú²{¦bªº²Â¤èªk¬O¨C¦¸³£­n¤â°ÊÀˬdµ§¼Æ¹ï¤£¹ï¡A«D±`¤£«K¡A
ÁÙ¬O§Ú¥i¥H¥Î¼Ï¯Ã¤ÀªRªí¨Ó°µ©O¡H

test.zip (6.92 KB)

¦^´_  gong

·PÁÂgong»PANGELA«e½ú
§Ú³Ì«áÀ³¸Ó·|¥Î=LOOKUP(9.9E+307,(SUM(sheet1!C:C)-sheet1!C$3))
ÁÂ ...
maxchou µoªí©ó 2011-8-29 17:07


=LOOKUP(9.9E+307,(SUM(sheet1!C:C)-sheet1!C$3)) = SUM(sheet1!C:C)-sheet1!C$3)
¨º¸òª½±µ¥Î= SUM(sheet1!C:C)-sheet1!C$3) ¤@ ¼Ëªºµ²ªG.
«Øij¥Î8FÅÇ¥Sªº¤½¦¡

TOP

¦^´_ 9# gong

·PÁÂgong»PANGELA«e½ú
§Ú³Ì«áÀ³¸Ó·|¥Î=LOOKUP(9.9E+307,(SUM(sheet1!C:C)-sheet1!C$3))
ÁÂÁÂÅo¡ã

TOP

¦pªG¨S¦³sum(),2005¤S¬O¤å¦r,¨º¤°»ò³£¤£­n,¥u­nsum(sheet1!c:c)´N¥i¥H¤F
¦pªG¦³sum(),¨º´Nsum(sheet1!c:c)/2
¦pªG2005¬O¼Æ¦r,sum(sheet1!c:c)-sheet1!c$3
¤S¬O¼Æ¦r¤S¦³sum(),(sum(sheet1!c:c)-sheet1!c$3)/2
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

=SUM(OFFSET(sheet1!$A$3,1,MATCH(B$1,sheet1!$3:$3,0)-1,COUNTA(sheet1!$A:$A)-3,))
¦pªG¬[ºc¤£ÅÜ,¤£ºÞ¦³¨S¦³sum(),À³¸Ó³£¾A¥Î,¦pªG»Ý­n¥i¥[±Æ¿ù§@ªk
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 5# gong


ÁÂÁÂgong«e½ú¡A¤@¼Ëªº°ÝÃD­n½Ð±Ð¡A¦pªG¤U¦¸Åܦ¨50µ§¡A§Ú¤S¨S¦³¦bsheet1¤â°Ê¥[¤Wsum¡A
¨º¦³¤°»ò¤è¦¡¥i¥Hª½±µ¦bsheet2¥[Á`sheet1ªº¸ê®Æ©O¡H¦Ó¥B2005¤S¬O¦~«×¡A¤£±o³Q¥[Á`¦b¤@°_¡C
¥ýÁÂÁÂÅo¡I

TOP

¦^´_ 2# ANGELA

ÁÂÁÂANGELA«e½ú¡A¤£¹L§Ú¬ðµM·Q¨ì¡A¤U¦¸¤ñ¼ÆÅܦ¨50µ§®É¡A§Ú¦pªG¨S¦³¦bsheet1¤â°Ê¥[¤Wsum¡A¨º­ì¤½¦¡´N¥¢®Ä¤F¡A
©ó¬O§Ú¦Û¤v¶Ã§ï¦¨=LOOKUP(9.9E+307,sum(sheet1!C:C))¡A¥i¬O¦]¬°§Úªº2005¬O«ü¦~«×¡A¤£¯à¥[Á`¡A
§Ú¤S¥u¯à¦b¸ÓÀx¦s®æ§â2005§ï¦¨¤å¦r¡A¦p¦¹¤@¨Ó¡A¬O¥i¥H¹F¦¨§Úªº¥Øªº¡A
¦ý§Ú§ó·Q½Ð°Ý«e½ú¡A¦³§ó¤è«Kªº¤è¦¡¥i¥H¨Ï¥Î¶Ü¡H
¥ýÁÂÁÂÅo¡I

TOP

°Ñ¦Ò
=OFFSET(sheet1!C$1,COUNTA(sheet1!$A:$A),)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-8-26 23:36 ½s¿è

9.9e+307 ¡@¬Oexcel»{¥iªº¨ú¤j¼Æ
9.9*10000000000¦@307­Ó0

TOP

¦^´_ 2# ANGELA

ª©¥D±z¦n¡I¥i§_¸ÑÄÀ¤@¤U9.9E+307¬O¤°»ò·N«ä©O?¾ã­Ó¨ç¼Æ¤S¬Oªí¥Ü¤°»ò·N«ä©O?·Ð½Ð½ç±Ð¡A·P®¦±z¡I
=LOOKUP(9.9E+307,sheet1!C:C)

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD