=sumif（C1:C100,A1:A100,"a",B1:B100,">2000),B1:B100,"<3000")
2007版本可以用SUMIFS函数C列输入公式=sumifs(B:B,A:A,"特定名称",B:B,">2000",B:B,"<3000")
高版本的sumifs，普通公式。或者低版本的sumproduct
=SUMIFS(C:C,A:A,"名称“,B:B,">2")
