在指定Countif函数的情况下:一、区间内人数L12=countif($F$3:$F$100,">=580")M12=countif($F$3:$F$100,">=530")-countif($F$3:$F$100,">=580")N12=countif($F$3:$F$100,">=480")-countif($F$3:$F$100,">=530")O12=countif($F$3:$F$100,"=!")三、区间内占总人数百分比L13=text(L12/$L$16,"0.00%")右拉到O13...
|
|