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