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

[µo°Ý] ¨ú±o¤£¦Psheet­¶¦¸¼Æ­È

[µo°Ý] ¨ú±o¤£¦Psheet­¶¦¸¼Æ­È

¦^¶Ç¤£¦Psheet­¶¼Æ­È.rar (9.02 KB)

½Ð±Ð¥ý¶i~
¦pªþ¥ó©Ò¥Ü¡A§Ú·Q¹F¦¨¨ú±o¤£¦Psheet©Ò­pºâ«áªº­È¡A¦³¤°»ò¤èªk©O?
ÁÂÁ¤j®a~~

=INDIRECT("Sheet2!R"&IFERROR(MATCH(Sheet1!A2+1,Sheet2!$A$2:$A$8,),COUNTA(Sheet2!D:D))&"C4",)

TOP

¦^´_ 2# ANGELA

¦^¶Ç¤£¦Psheet­¶¼Æ­È.rar (9.37 KB)

ÁÂÁÂANGELA¤j¤j¦^ÂÐ~
¨Ì±zªº¤è¦¡¥i¨D±oSHEET2 ¨Ì¤é´Á©Ò²Ö­pªº­È

¥i¬O§Ú§Æ±æ¯à¹F¦¨ SHEET1¡A·í§Ú¿é¤J¤é´Á®É¡A¦Û°Ê±a¤JSHEET2¸Ó¤é´ÁªºÁ`¦X¡A§Ú¦³­×¥¿EXCEL»¡©ú¡A·Ð½Ð±z¦A«ü¾É¤@¤U
·P¿E¤£ºÉ~~^^

TOP

¦^´_ 3# chi830

¨Ï¥Î¤£³W½dªº¸ê®Æ®w·|¼W¥[¤½¦¡ªº­t担
¤é´Á¤£¬Ù²¤¥Îsumproduct()²³æ¦h¤F
=SUMPRODUCT((A2>=Sheet2!$A$2:$A$12)*(Sheet2!$B$2:$B$12))-SUMPRODUCT((A2>=Sheet2!$A$2:$A$12)*(Sheet2!$C$2:$C$12))

   ¦pªG¤@©w­nªÅ¥Õ¥i°Ñ¦Òhttp://forum.twbts.com/viewthrea ... hlight=%C1%F4%C2%C3

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-9-19 23:23 ½s¿è

·PÁÂ ANGELA¤j¤j~
¦p±z©Ò»¡¡A¤é´Á¤£¬Ù²¤¡A´N§Y¬°©Ò¨D¤F¡AÁÂÁ±z³á
¥i½Ð±Ð¤@¤Usumproductªº¥Îªk¡A¬°¤°»ò­n(Sheet2!$A$2:$A$12)*(Sheet2!$B$2:$B$12)
¨º­Ó* ¬Oªí¥Ü­n²Ö¿n©Mªº·N«ä¶Ü?

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD