excel表格函数运用,筛选、求和!!!我是菜鸟,在线等!!!答:C3公式为:SUMIF(Sheet1!B3:B6,"王",Sheet1!C3:C6)C4公式为:SUMIF(Sheet1!B3:B6,"李",Sheet1!C3:C6)D3公式为:SUMIF(Sheet1!B3:B6,"王",Sheet1!D3:D6)D4公式为:SUMIF(Sheet1!B3:B6,"李",Sheet1!D3:D6)E3公式为:SUMIF(Sheet1!B3:B6,"王",Sheet1!E3:E6)E4公式为:...