<p></p><p>1组 10137 zhuzhu0517</p><p>第一题:=SUMIF(A6:D14,"??R*",B6)</p><p>第二题:=SUMIF(B2:$M$2,$B$18,B3:M3)</p><p> =SUMIF($B$2:$M$2,"<="&$B$18,B3:M3)</p><p>第三题:=SUM(SUMIF(A3:A22,{"<-1",">5","9"},A3:A22)*{1,1,-1})</p><p>第四题:=SUM((B4:B30=B36)*C4:C30)</p><p> =MAXA(SUMIF(A4:A30,{"1月份","2月份","3月份","4月份"},C4:C30))</p>
[此贴子已经被作者于2009-11-10 23:36:17编辑过] |