>>180
Sub FOO()
If Not (Cells(1, 8) = "集計" Or Cells(1, 8) = "総計") Then
Rows("1:1").Delete Shift:=xlUp
End If
End Sub