假如数据在A列,则在B1输入=countif(a:a,">=40)-countif(a:a,">60"),这是求出大于等于40且小于60的数的个数.
你所说的各个数之和是指那些数之和呢?是所有的n个数之和吗?如果是,则在C1单元格输入=sum(a:a)回车即可
在表格一列中有n个0到100的数,如何求出大于等于40且小于60的数的个数和各个数值的和?
假如数据在A列,则在B1输入=countif(a:a,">=40)-countif(a:a,">60"),这是求出大于等于40且小于60的数的个数.
你所说的各个数之和是指那些数之和呢?是所有的n个数之和吗?如果是,则在C1单元格输入=sum(a:a)回车即可