在excel中,有一组数据,比如1,8,8,12,25,5,3,2,0,5,6,8,15,14,先选出大于3的数字,然后将选出的数字乘以2,最后求和
将1,8,8,12,25,5,3,2,0,5,6,8,15,14,填入A1到A14中,A15中填入=2*SUMIF(A1:A14,">3")