¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:14 ½s¿è
ªþ¥ó¬O§Úºô¸ô¤W¬Ý¨ìªº
½Ð°Ý¦³¤H¥i¥H¥Õ¸Ü¸ÑÄÀ¤@¤U¶Ü
LOOKUP(1,1/((A3:A26=E3)*(B3:B26=F3)),C3:C26)
³o¦U¦³ÂI¹³sumproduct
¦ý¬O§Ún·j´Mªº³¡¥÷¥Îsumproduct§ì¤£¨ì¸ê®Æ
¥ÎlookupÁöµM§ì¨ì¸ê®Æ
¦ý¬O¤£ª¾¹D¬°¤°»ò¥¦¥i¥H§ì¨ì
§Æ±æ¦³¤H¸Ñµª¤@¤U
¦bLOOKUP¤¤¨Ï¥Î¨âÓ±ø¥ó.rar (32.2 KB)
|