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

averageifs ¦P¤@­ÓÄæ¦ì¡A¤£¦P­È

averageifs ¦P¤@­ÓÄæ¦ì¡A¤£¦P­È

¤j®a¤È¦w¡A·Q½Ð±Ð­Ó°ÝÃD
§Ú·Q²Î­p¥­§¡­È¡A©Ò¥H¥Îaverageifs¨Ó­pºâ

§Ú·Q¥h­pºâ¬P´Á¤@ ~ ¤Gªº¥­§¡­È,©Ò¥H§Ú¤½¦¡³o¼Ë¼g

=AVERAGEIFS(M4:M33,B4:B33,"¬P´Á¤@",B4:B33,"¬P´Á¤G")

¥i«o¤£¦æ¡A¥X²{#div/0!

­Y®³±¼¬P´Á¤Gªº³¡¤À¡A«o¥i¥Hºâ¥X¡A¬O§ÚªºÅ޿褣¹ï¶Ü??

data.png
2016-6-27 16:30

­è´ú¸Õ
  1. =AVERAGEIFS($M$4:$M$33,$B$4:$B$33,"<>¬P´Á¤@",$B$4:$B$33,"<>¬P´Á¤G",$B$4:$B$33,"<>¬P´Á¤T",$B$4:$B$33,"<>¬P´Á¥|")
½Æ»s¥N½X
¥i¥Hºâ¥X¤­ ~ ¤éªº¥­§¡¡A¦ý¬°¤°»ò¥Î=«o¤£¯à©O???

TOP

¦^´_  owenchen0911
°²³]¡u¤é´Á¡v¸ê®Æ¦ì©óAÄæ¡A¡u¬P´Á¡v¸ê®Æ¦ì©óBÄæ¡A¡uªM¼Æ¡v¸ê®Æ¦ì©óCÄæ
1.»s§@°ÊºA½d ...
p212 µoªí©ó 2016-6-28 09:55




ÁÂÁ¤j¤jªºÀ°¦£¡A¦ý¥i½Ð°Ý¤@¤U¬°¤°»ò§Úªº¼gªk¤£¯à©O??

¦A¦¸ÁÂÁÂ

TOP

¦^´_  owenchen0911


    §A¨S·d²M·¡¨ç¼Æªº¥Îªk
#1
=AVERAGEIFS(M4:M33,B4:B33,"¬P´Á¤@",B4:B33,"¬P ...
KCC µoªí©ó 2016-6-28 10:28




ÁÂÁ¨â¦ì¤j¤jªº«üÂI

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD