作者:乔山办公网日期:
返回目录:excel表格制作
求平均百值公式改为这样:
=SUM(Sheet1:Sheet25!度C25)/SUMPRODUCT(N(N(INDIRECT("Sheet"&ROW(1:25)&"!C25"))>0))
如果一定要用AVERAGE的,公式如下,但这专是数组公式,按三键CTRL+SHIFT+回车。
=AVERAGE(IF(N(INDIRECT("Sheet"&ROW(1:25)&"!c25")),N(INDIRECT("Sheet"&ROW(1:25)&"!c25"))))
算有成绩的人有多少用这公属式:
=SUMPRODUCT(N(N(INDIRECT("Sheet"&ROW(1:25)&"!C25"))>0))
=AVERAGE(IF((A1:A4>=2)*(A1:A4<=2.5),B1:B4))
按百Ctrl+Shift+回车键结束
2007以上的度版本,内可以容用:
=AVERAGEIFS(B1:B4,A1:A4,">=2",A1:A4,"<=2.5")
=averageif(A1:A10,">"&B1)
或不用B1,写成:
=AVERAGEIF(A1:A10,">"&AVERAGE(A1:A10))