averageifs ¦P¤@ÓÄæ¦ì¡A¤£¦PÈ
- ©«¤l
- 8
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2016-5-24
- ³Ì«áµn¿ý
- 2016-7-9
|
averageifs ¦P¤@ÓÄæ¦ì¡A¤£¦PÈ
¤j®a¤È¦w¡A·Q½Ð±ÐÓ°ÝÃD
§Ú·Q²Îp¥§¡È¡A©Ò¥H¥Îaverageifs¨Ópºâ
§Ú·Q¥hpºâ¬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§ÚªºÅ޿褣¹ï¶Ü??
|
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2016-5-24
- ³Ì«áµn¿ý
- 2016-7-9
|
è´ú¸Õ- =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??? |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2016-5-24
- ³Ì«áµn¿ý
- 2016-7-9
|
¦^´_ 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¦¸ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2016-5-24
- ³Ì«áµn¿ý
- 2016-7-9
|
¦^´_ 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 |
|
|
|
|
|
|