原过程增加几句即可: Sub 在单元格中对多表进行条件求和() For j = 2 To 5 xm = Cells(j, 3) X = 0 For sht = 1 To Sheets.Count With Sheets(sht) For H = 2 To 7 If .Cells(H, 1) = xm Then X = X + .Cells(H, 2) Next H End With Next sht Sheets(1).Cells(j, 4) = X MsgBox "两表中姓名为" & xm & "的总和是" & X Next j End Sub