=SUM(COUNTIF(K4:K33,{">=20",">30"})*{1,-1})
问题描述:
=SUM(COUNTIF(K4:K33,{">=20",">30"})*{1,-1})
答
统计K4到K33这个区域内大于等于20小于等于30的数值的个数.
=20",">30"})*{1,-1})" /> =20",">30"})*{1,-1}) - 作业答案大全" />
=SUM(COUNTIF(K4:K33,{">=20",">30"})*{1,-1})
统计K4到K33这个区域内大于等于20小于等于30的数值的个数.