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

[µo°Ý] sumif¦p¦ó¥[Á`°ÊºA¦ì¸m

ªþ¥ó¤¤²LÂŦâ©M²`ÂŦâ¬O³o¦¸­n§ïªº¸ê®Æ
PD_PD_¥DÀɮ׬Oraw data
¥H«e¤½¥q¿é¥Xªºraw data§Î¦¡§Ú¥u»Ý­nª½±µ§ä§Ú»Ý­nªºdataÂà¶K¹L¨Ó
²{¦b«h»Ý¥[Á`3µ§¸ê®Æ
¥H«e§Ú¥i¥H¨Ï¥ÎActual_move³o­Ó¦WºÙ§â¾ã­Ó½d³ò¿ï¨ú«áª½±µ¥Îindex§ä¨ì§Ú»Ý­nªº­È
²{¦b¤@©w­n°µ¥[Á`
²LÂŦâ´N¬O§Ú¥Î¤ñ¸û²Âªº¤èªk¤@­Ó¤@­Ó§ä½d³ò(¦@©w¸q6­Ó¦WºÙ)
¤ÑªÅÂŦpªG¥Î³o­Ó²Â¤èªk·|¦A«Ø¥ß4­Ó¦WºÙ(²Ä¤G®æ­n§ìU_Idle¡BU_ShotDown¡BS_Shortage)

¤ÑªÅÂŪº³¡¥÷©|¥¼­×§ï
¦b¼Ð¥ÜÃC¦âªº³¡¥÷¥Ø«e±o¨ìªºµ²ªG¦ü¥G¥¿½T
¦ý©¹¥k½Æ»s¤½¦¡...©Ò¦³Àx¦s®æ³£·|¥h7/1ªº¸ê®Æ°Ï°µ¥[Á`
²Ä¤@­Ó·Q½Ð¤j®aÀ°§Ú¬Ý¬Ýsum_range¸Ó«ç»ò­×§ï¤~¯à¤£¥Î¦A©w¸q¦WºÙ
²Ä¤G­Ó¦]¬°§ìªºªF¦è¸û½ÆÂø...§Úªº¯à¤O·|¼g3­Ósumif¨Ó¦A°µ¥[Á`(Ãþ¦ü=sum(SUMIF(index,"*"&"¤p­p",idle),SUMIF(index,"*"&"¤p­p",shortage),SUMIF(index,"*"&"¤p­p",shotdown))ÁÙ¨S¼g´Nı±o¦Û¤v³o¤èªk«Ü²Â, ·Q½Ð¤j®aÀ°¦£¬Ý¬Ý«ç»ò¼g¤ñ¸û¦n)

ps. ³Ì«áÀÉ®×ÁÙ¬O¨S°µ¤°»ò­×§ï, ¶Ç³oÀÉ®×¹ê¦b¦³ÂI¤ßµê
sumif.rar (46.03 KB)

TOP

³á³á!
¨H¤U¥h¤F
¥i§_½Ð¤j®a¨ó§U...ÁÂÁÂ

TOP

©p³o¼Ëªº´£°Ý¥s¤j®a¦p¦ó¨ó§U¡H
©pªº±Ô­zÀ³¸ÓµÛ­«©ó­þ±i¤u§@ªíªº­þ­Ó¦ì¸m¡A¶·­n«ç¼Ëªº­pºâ¤è¦¡»P±o¨ì¤°»òµ²ªG
¶Ç­ÓÀɮפW¨ÓÅý¤H¥hºCºC²q´ú©p­n°µ¤°»ò¡A¦h¥b¤H³£¨S³o­Ó®É¶¡»P¿³½ì¡C

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD