averageifs ¦P¤@ÓÄæ¦ì¡A¤£¦PÈ
- ©«¤l
- 85
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 126
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-8-31
- ³Ì«áµn¿ý
- 2022-4-15
|
¥»©«³Ì«á¥Ñ KCC ©ó 2016-6-28 10:37 ½s¿è
¦^´_ 4# owenchen0911
§A¨S·d²M·¡¨ç¼Æªº¥Îªk
#1
=AVERAGEIFS(M4:M33,B4:B33,"¬P´Á¤@",B4:B33,"¬P´Á¤G") ¬O¨D ¦P®É¬O¬P´Á¤@¤]¬O¬P´Á¤G¡A©Ò¥H·íµM¬O¨S¥bÓ³y¦¨0°£¿ù»~
µ¹¤@Ó¤½¦¡°Ñ¦Ò
=SUM(SUMIFS(M4:M33,B4:B33,{"¬P´Á¤@","¬P´Á¤G"}))/SUM(COUNTIFS(B4:B33,{"¬P´Á¤@","¬P´Á¤G"}))
#2
=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´Á¥|")
¨D¦P®É¤£µ¥©ó¬P´Á¤@¡B¬P´Á¤G¡B¬P´Á¤T¡B¬P´Á¥|¡A©Ò¥H·|§ä¥X ¬P´Á¤¡B¬P´Á¤»¡B¬P´Á¤Ñ ªºÈ¨D¥§¡
-----------
µ¹Ó«Øij¡A°Ý°ÝÃD¯à´£¨ÑªþÀÉ¥[¤W¾A·íªº»¡©ú·|¦n¤@¨Ç |
|
|
|
|
|
|