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

Ãö©óAVERAGEIF¨ç¼Æ¼gªk¡A½Ð°Ý­þ¸Ì¦³¿ù»~?

Ãö©óAVERAGEIF¨ç¼Æ¼gªk¡A½Ð°Ý­þ¸Ì¦³¿ù»~?

3.jpg
2016-4-29 21:21


Ãö©ó¤W¹ÏÅã¥Ü¡A¤u¸¹F4352¦³7µ§¼Æ¶q«o±a¤£¥X¥­§¡®É¶¡¡A½Ð°Ý¦U¦ì¾Çªø/¾Ç©n§Ú¨ç¼Æ­þ¸Ì¦³¼g¿ù?¬O§_¥i¥HÀ°¦£­×¥¿¡AÁÂÁÂ!!

§Ú¨ç¼Æ¼gªk
=IF(AVERAGEIFS(detail!P:P,detail!O:O,"*"&E49&"*")=0,IF(ISERROR(AVERAGEIFS(detail!P:P,detail!I:I,E49)),0,AVERAGEIFS(detail!P:P,detail!I:I,E49)),AVERAGEIFS(detail!P:P,detail!O:O,"*"&E49&"*"))

¸ÑÄÀ¤@¤U¬°¦ó­n³o¼Ë¼g¡A¦p¤U¹Ï¤@»P¹Ï¤G

±¡ªp¤@:
OÄæ¦ì¡A­n¥h§ìÃöÁä¦r : ¤u¸¹¡A¦p¨S¤ñ¹ï¨ì¤u¸¹  §Y¸õ¨ìIÄæ¦ì¤ñ¹ï¬O§_¬°¥¿½T¤u¸¹¡A¦p¥¿½Tªº¤u¸¹¡A§Yºâ¥XPÄæ¦ìªº¥­§¡®É¶¡

±¡ªp¤G:
OÄæ¦ì¡A­n¥h§ìÃöÁä¦r : ¤u¸¹¡A¦p¦³¤ñ¹ï¨ì¤u¸¹ ¡A§Yºâ¥XPÄæ¦ìªº¥­§¡®É¶¡

1.jpg
2016-4-29 21:28
  
2.jpg
2016-4-29 21:30

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD