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

Excel 2007µLªk§¹¾ã±Æ§Ç

Excel 2007µLªk§¹¾ã±Æ§Ç

Book5.rar (49.61 KB)
¦pªþ¥ó,§Ú·Q­n¨Ì·ÓÄæF±Æ§Ç(duration),¦ýÁ`¬OµLªk±Æ¨ìEÄæ©MGÄæ,¦n¹³¬O sumifªº¤½¦¡µLªk¸òµÛ±Æ§Ç
§Úªº¨Ó·½Àɮ׳£¨Ó¦Û©ódetail¨º±iªí,¦ý­«ÂI¥u¦³¦bgrouping±Æ§Çªº°ÝÃDµLªk¸Ñ¨M.½Ð¤j®aÀ°À°¦£,ÁÂÁÂ
Jeffrey Chen

E4=SUMIF(detail!$D:$D,INDIRECT("RC1",0),detail!$S:$S)/INDIRECT("RC7",0)
G4=SUMIF(detail!$D$2:$D$403,INDIRECT("RC1",0),detail!$M$2:$M$403)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁª©¤jªº¤½¦¡.¥i§_¦b½Ð±Ð¨â­Ó°ÝÃD
1.¬°¤°»òsumifªº¤½¦¡¦b±Æ§Ç®É·|¶]±¼?³o¼Ë¬O¤£¬O¥H«á­n±Æ§Ç³£³Ì¦n¤£­n¥Î³o­Ó¤½¦¡?
2.indirectªºÅÞ¿è­È©ñ"0"©M"false"¬O§_¬°¦P¼Ë·N«ä?³£¬O¥Nªí¥ÎR1C1ªí¥Üreference?
Jeffrey Chen

TOP

¦]¬°¤½¦¡¥HA1°Ñ·Ó§Î¦¡ªí¥Ü¡A°Ñ·Ó¦ì¸m§ïÅܤ½¦¡´N·|¸òµÛ§ïÅܤº®e
©Ò¥H¨Ï¥ÎR1C1¨Ó°Ñ·Ó®É´N¤£·|¦³²¾¦ìªº°ÝÃD
¨ç¼Æªº¤Þ¼Æ¤¤FALSE¤j³£¥H0ªí¥Ü¡ATRUE¥H1ªí¥Ü
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¾Ç²ß¤F,ÁÂÁÂ
Jeffrey Chen

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD