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

[µo°Ý] ¦³¤½¦¡¬O¹J¨ì¬Y©w±¡ªp¤U,¦Û¤v(¥]¬AÀx¦s®æ¤ºªº¤½¦¡)·|³Q²¾°£¶Ü?

[µo°Ý] ¦³¤½¦¡¬O¹J¨ì¬Y©w±¡ªp¤U,¦Û¤v(¥]¬AÀx¦s®æ¤ºªº¤½¦¡)·|³Q²¾°£¶Ü?


¤W¹Ï¬OD7=SUM(D4:D6)
        E7=SUM(E4:E6)
        F7=SUM(F4:F6)
¦pªG§Ú·Q·í¼Æ­È¬O=11®É,·|³Q²¾°£¦p¤U¹Ï(¥]¬A¤½¦¡),¦³¤èªk§¹¦¨¶Ü?VBA¤]¥i, ÁÂÁ¤j®a

¨ç¼Æ¥i¥H¥Î±ø¥ó®æ¦¡Åý¥LÅã¥Ü¬°¥Õ¦r©Î¤£­n¥[Á`
­n§R°£­n¨D±Ðvba

±ø¥ó®æ¦¡
=SUM($E$4:$E$6)=11±ø¥ó³]¬°¥Õ¦r

¦X­p­nÅã¥Ü¬°ªÅ¥Õ
=if(SUM($E$4:$E$6)=11,"",SUM($E$4:$E$6))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD